Automatically transfer data from one worksheet to another [Closed]

Report
Posts
1
Registration date
Wednesday November 19, 2014
Status
Member
Last seen
November 19, 2014
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
Hello,

I have an Excel workbook with two worksheets in it. The first worksheet is rows of data organized by Region, Client, Date, Product, Rep, etc. that is updated every week with new data. The second worksheet is filled with different =SUMIF formulas extracting specific data from the first worksheet automatically. I am stuck trying to figure out a way to automatically list our top clients for each region onto the second worksheet, so I don't have to manually type in our clients by region each week.

=VLOOKUP does not seem to be the answer, I have a feeling it may be a macro with coding which I am unfamiliar with. If anyone could PLEASE help me, I'd greatly appreciate it. You'd be making my life much easier and have my bosses think I'm super smart.

1 reply

Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
Hello Vamus,

Is it just the client name that you want to transfer or the client name + region or the whole row?

Cheers,
vcoolio.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!