Excel - copying relevant information from multiple files

[OMoore]

Hi All,

This query may be a little too advanced for this forum but here goes anyway!

I have 66 Excel files each of which contains information I need. The need to copy it from it's current file to a new worksheet, pasting from each file I open.

he data I need is identified in the spreadsheet with a number on the row before the information begins and a number on the row after...etc

500.0018
all required information here
all required information here
all required information here
500.0018

I'd like to be able to open the file, quickly go to the lines I need, copy them and paste into an open workbook.

Any ideas that could point me on the right track?

Thanks
Owen

 

[SkipVought]

Hi,

"...identified in the spreadsheet with a number on the row before the information begins and a number on the row after...etc"

Always the same number in every workbook on every sheet?


Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[AnotherHiggins]

This can be done relatively easily using a macro.

Please repost your question in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[OMoore]

Yes Skip always the same number in every workbook as it's a cost account code which I'm hoping will make it easier!?!

John - I'll repost.

Thanks
Owen