Move to every record on every worksheet

A

asrul

Hi All,
I'm rather newbie in excel and programming is
something rough for me.

I want to automate a search and then paste the
result in a new workbook.

I have folder and it contains many workbook in
it.The workbook were used to record to the data.
Usually the workbook has around 33 sheets.

The sheets I want to look in to were named with
number 1 untill 31 ( actually represent date in a month)
So the others 3 sheet were named with something else
and I'll ommit the another 3 sheets.

The problem is: how to create the code to loop through
the worksheets,through the workbooks,and through the
sub folder to find the records and then copy-paste them
into a new/specified workbooks.

Hope somebody would like to help.

Have a good day.
Regards,
 
D

Don Guillett

How about some more detail of your layout and what you are looking for. Or,
send your workbook to my address below along with a snippet of this message
on an inserted sheet, a complete explanation, and before/after examples.
 
R

ryguy7272

Still trying to get this data imported as it appears on the web page (rows
and columns, rather than just one long column). I've tried a few more lines
of code; nothing seems to work. Any other ideas Ron?

Thanks,
Ryan--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a workbook from every worksheet in your workbook 7
Copy cell value from one worksheet to matching worksheet in another workbook 4
Copy every worksheet 2
Run macro on every worksheet 4
loop through the workbook and paste every sheet it into newly createdworkbook with same sheet name 2
Open four Wbooks, copy four columns from each to Master Wbook 16
VBA macro guru help needed! 1
copy past two existing sheets into 30 workbooks 4

Top