IntegrityStaffing
New Member
- Joined
- Apr 20, 2011
- Messages
- 1
Hi! I'm very new to macros. Here is what I want to do.....
I have already created a macro that I will use daily with changing data, however I want to go a step further.
My macro currently formats my data how I want it, but I want to cut a certain amount of this data (that will change daily), remove it from my initial spreadsheet and paste it to a new file/ workbook.
So..... I have data that is split into Days and Nights (shifts) currently. Now, I want my end result to have my "Days" data on one workbook......I want excel to open a new workbook....cut my "Nights" data from original....then paste it to the newly opened workbook along w/ the column headers. This way I can save them as a "days" file and "nights" file.
Can anyone help me?
Thanks!
I have already created a macro that I will use daily with changing data, however I want to go a step further.
My macro currently formats my data how I want it, but I want to cut a certain amount of this data (that will change daily), remove it from my initial spreadsheet and paste it to a new file/ workbook.
So..... I have data that is split into Days and Nights (shifts) currently. Now, I want my end result to have my "Days" data on one workbook......I want excel to open a new workbook....cut my "Nights" data from original....then paste it to the newly opened workbook along w/ the column headers. This way I can save them as a "days" file and "nights" file.
Can anyone help me?
Thanks!
