copy data from numerous sheets to a master sheet

L

lwleedy

A friend of mine, a Police Crime Analyst has a workbook that keeps data
for each month in a seperate sheet. Each sheet Jan, Feb, Mar, etc could
have different number of rows. They all start at row 14 but could have
20 to over 100 rows.

She then has a yearly total sheet that she now copies and pastes all
the data from the monthly sheets.

I have used John Walkenbach's PUP insert function but it's not
automatic.

Is there a way to have a Macro run that would prompt her for the sheet
then import all the records starting at a certian row.

Thanks,
Lenny
 

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

Copy Data from One sheet to Different Sheets 1
Copy Multiple Sheets Into One Sheet 4
Formula to consolidate 130 sheets into a summary sheet 6
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
More Rows/One Sheet vs More Sheets/Less Rows for best performance? 1
Reference cell values from other sheets in a function 2
moving rows to another sheet 3
Pulling Data from Master Table Dynamically Into Secondary Workbook Sheets 1

Top