Transferring Data Sets Between Worksheets

**eichstadt28** · 04-13-2009, 10:56 PM

I've got two different worksheets that I would like to combine data from. In one worksheet, I've got about 40 sets of data that are grouped together (A1, A2, A3, A4, etc.).

I'd like to be able to copy specific data sets to another worksheet using some sort of lookup feature or something like that. For example, is there any way that I can type the information of A1 or lookup the information in cell A1 of the other sheet and have A2, A3, A4, A5, etc. of that sheet copied into my destination sheet?

Hopefully, I explained this well enough. Thanks, in advance, for your help.

**JBeaucaire** · 04-13-2009, 11:13 PM

Post up a workbook showing what you're talking about, both the data set and the desired result sheet. Please don't dumb it down too far, make sure the sample data fully represents the hurdles that have to be overcome.

Click on GO ADVANCED on your next post and use the paperclip icon to attach your sample sheet.

**eichstadt28** · 04-14-2009, 08:27 AM

Here is an example of the workbook with the information that I would like to transfer. In the destination workbook (not completed, yet), I would like to be able to either type 'Wages' or look up 'Wages' from this worksheet and have cells A5-N5 transferred. Or type or lookup 'Utilities' from this sheet and have A12-N12 transferred to my new workbook. Is there any way that I can do this?