H
hiyah75
I have an excel spreadsheet that contains a tab (worksheet) for each month of
2008 for new customers and a tab each month for customers who had upgrades.
We fill them out daily for our commissions.
At the end of the month all of that information is supposed to be
transferred to a Master Customer List that dates back years.
It hasn’t been done since June due to employee changeovers. It hasn’t been a
big deal as we have the monthly sheets we can reference.
I started to just cut and paste each month. Both workbooks have the same
information in them……however the columns are in different orders so cutting
and pasting won’t work unless I re-arrange all the columns...which I'll do if
I have to.
Is there an easier way to just merge them and have the Master Customer List
just pull the info from the monthly sheets?
2008 for new customers and a tab each month for customers who had upgrades.
We fill them out daily for our commissions.
At the end of the month all of that information is supposed to be
transferred to a Master Customer List that dates back years.
It hasn’t been done since June due to employee changeovers. It hasn’t been a
big deal as we have the monthly sheets we can reference.
I started to just cut and paste each month. Both workbooks have the same
information in them……however the columns are in different orders so cutting
and pasting won’t work unless I re-arrange all the columns...which I'll do if
I have to.
Is there an easier way to just merge them and have the Master Customer List
just pull the info from the monthly sheets?