Blend two worksheets?

MsCynic

Board Regular
Joined
May 21, 2006
Messages
122
Hi guys, I'm not sure if this is possible, and not being accountant-minded I can't think of any easy way anyway but here is my dilemma:

I have had sent to me sales figures for one of my branches and the accountant has divided them into worksheets of July-June years. So what I have is 12 months from July 05 on one worksheet and three months from July 06 on a second. Agent names run from top to bottom and monthly figures run from left to right.

I want to view the entire period from July 05 to September 06 on one worksheet. You'd think it would be a simple matter of cutting and pasting the three months onto the end of the 12 month worksheet. Unfortunately the agent names are different between the two worksheets.

I hoped there might be a way to "blend" or "merge" even, but for the life of me cannot think how it would be done.

I would be really pleased if anyone has any suggestions about how to resolve this dilemma.

Thanks in advance,
Jo
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Jo

Not sure if you want a macro / formula solution, or some ideas on an approach to this, so I'll go for the latter.

1) Create a new sheet.
2) Create a list of unique names in column A. There are various ways to do this (bring them both in, sort, delete duplicates or put them together somewhere else, then use a filter to generate a unique list).
3) Use VLOOKUP functions to bring in the relevant data from the source sheets.


HTH

Tony
 

MsCynic

Board Regular
Joined
May 21, 2006
Messages
122
Hi Tony, thanks - you are right, I was hoping for exactly that kind of suggestion.

I've never heard of the vlookup function before so have started reading up about it. Don't be surprised if I post back with more questions ...

Thanks again,

Jo
 

Forum statistics

Threads
1,136,651
Messages
5,677,004
Members
419,667
Latest member
MegEri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top