3 {{ upvoteCount | shortNum }}
3 {{ upvoteCount | shortNum }}

Any Excel Wizards Out There?

by cozandeffect
2 replies
Hi Everyone,

I'm a relative newbie with Excel, so please be gentle

Here's what we need to do:

We are compiling one master spreedsheet from many smaller ones and I need to figure out how to copy them quickly and efficiently. For example:

Small Spreadsheet:

Column B is marked as P, M, C or S. This represents the type of the account.
Column C is the name of the account.


Master Spreadsheet:

We have a column for each account type (P,M,C,S)

Can we use a formula/macro to automatically copy columns B and C from the small sheet and organize them accordingly in the Master Spreadsheet?

For example:

Small spreadsheet:

P Account Name1
M Account Name 2
M Account Name3
C Account Name4
M Account Name5

would appear in the Master Spreadsheet as:

P M C
Account Name1 Account Name2
Account Name1 Account Name3 Account Name4
Account Name1 Account Name5




I'm sure this may seem confusing. My apologies, I'm struggling to wrap my head around it.

Any help is greatly appreciated.

Thanks!

Coz
#excel #wizards
  • Profile picture of the author kingW
    Hi,

    There are 2 methods that you can use:
    1. Use lookup command. Either vlookup or hlookup or just lookup.
    2. Use a pivot table.

    Go google those 2 functions. They are not difficult as they look once you understand the concept.

    Hope that's help.
    {{ DiscussionBoard.errors[1531967].message }}
  • Profile picture of the author JoeOFarrel
    Vlookup. pay attention to the format of the cells you are comparing. Won't work though if you have multiple cells with the same value in the first column
    {{ DiscussionBoard.errors[1532529].message }}

Trending Topics