By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,988 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,988 IT Pros & Developers. It's quick & easy.

Getting Data from Worksheet which matches Cell reference

P: 15

I have a workbook with around 28 worksheets, I have put together a macro which imports the data from each of the 28 different textfiles into it own sheet. Each sheet is named after the text filename.

I want to create a sheet which pulls all the data together. But I need the data in a particular order. In column A I have listed the file names in the order I need. These filenames correspond to the sheet names. I want Column B then to display data from a particular cell within the worksheet only if the sheet name matches the filename I have in Column A.

any help would be appreciated

Dec 6 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.