search for data in different worksheets

[SharonMee]

Hi All:

I have a couple of workbooks open (with a code someone helped with and it works fine).

In my present worksheet, which is not included in the workbooks open, I would like to search for cell C3= Account Name e.g. Hortons and C4= Account Number e.g. 0010456 in the worksheets of the workbook open. The worksheet name I want to search in is Raw Data and is same name for all the workbooks open.

My question is: how do I write a maro to search cells c3 & C4 simultaneously of my working worksheet, and I want excel to copy the information found in column A, G, H & K of the raw data worksheets into my working sheet starting at A20, C20 E20 and F20, if it finds more than 1 row of data matching, it should insert rows to accomodate the date e.g. A21, C21, E21 and F21 e.t.c.

I know it's possible to do this because someone helped with opening all workbooks in a folder and I thought that was impossible.

Please help if you can,

Thanks again.

 

[SkipVought]

Sharon,

Your requirement has not been stated clearly.
Tell me how close I am.

You have a Working Workbook with your "present worksheet" that you're going to write data into. Furthermore, you have 2 cells. C3 & C4 containing an Account Name & Account Number respectively. I don't know what you want to do with these two values???

You have several other open workbooks, each of which has a sheet named "Raw Data" that you want to copy data from columns A, G, H & K into the working sheet starting at A20, C20 E20 and F20.

You never stated WHAT MATCHES WHAT???

You never described the structure of the data in Raw Data???

Does this data have headings?

Does it begin in ROW 1?

Shooting from the hip, it seems like using MS Query via Data/Get External Data -- Excel Files -- your workbooks containing Raw Data etc. All the tables could be joined using whatever account parameters that you never eexplained in your requirement, and the data could be returned to another sheet and then copied into A20, C20 E20 and F20.


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244