merge data

  • Thread starter Thread starter rvik
  • Start date Start date
R

rvik

hai,

i have a wbk containg numerous sheets. Each sheet contains unique dat
in standard format. I want a master sheet containg the data from al
the sheets in the wbk.

I could copy the rangefrom each sheet and paste it in the master sheet
but this exercise is tedious when you do it daily on 20 sheets.

I would like a macro for this. Also the numebr of sheets in the wb
varies daily

Thanksfor thehel
 
You must log in or register to reply here.

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

Save record Into master sheet! 1
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to Compile Data from Different Sheets 2
Excel Looping code.... 2
hide multiple worksheets based on a formula value in one cell 1
Copy some of selected columns to master sheet 1
Help with For...each...next 2
Data need to be copied as per sheet name 4

Back
Top