Copy compare worksheets

T

Thomp

Need some help thinking this one through. What I would like to do is
copy a daily worksheet to a Weekly worksheet that will be an
accumliation of the daily worksheets.

The trick here is the daily information mostly text data often times
includes not new data but just updated data that would need to be
updated on the weekly spreadsheet.

Sometimes the data is in fact new and will need to also be added to
the weekly worksheet..

Looking for help in how best to do this with Macro..Dont think
consolidation works as not adding up data but rather adding new rows
and updating information

thanks for your thoughts
 
D

Don Guillett

Need some help thinking this one through. What I would like to do is
copy a daily worksheet to a Weekly worksheet that will be an
accumliation of the daily worksheets.

The trick here is the daily information mostly text data often times
includes not new data but just updated data that would need to be
updated on the weekly spreadsheet.

Sometimes the data is in fact new and will need to also be added to
the weekly worksheet..

Looking for help in how best to do this with Macro..Dont think
consolidation works as not adding up data but rather adding new rows
and updating information

thanks for your thoughts

Are you saying you have ONE file or many?
If one file with many daily sheets, why wasn't it one sheet to start with and then use filters, etc..
If desired, send your file to dguillett1 @gmail.com with this msg and a complete explanation.
 

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

Top