LearningVBA
New Member
- Joined
- Sep 16, 2006
- Messages
- 14
I've had a look through various posts on this forum and am unable to find what I'm after (perhaps I'm doing the search wrong) so have decided to ask a question.
My current workbook holds 20 worksheets (some are called Log, Report1, Report2, Records and FilterData). In the sheet called Records I have a large amount of data (43252 records), the identifier being in column C. I'm filtering on column C and then copying and pasting into a sheet called FilterData.
What I would like to do is automate this process so that:-
1. The data is filtered copied/pasted into the FilterData sheet.
2. A new workbook is created with the sheets called Log, Report1, Report2 and FilterData with the data from the original file.
3. The new file to be saved with the name from cell C2 of the FilterData sheet.
4. The process to be repeated untill all records have been filtered.
Hope someone can assist this learner?
My current workbook holds 20 worksheets (some are called Log, Report1, Report2, Records and FilterData). In the sheet called Records I have a large amount of data (43252 records), the identifier being in column C. I'm filtering on column C and then copying and pasting into a sheet called FilterData.
What I would like to do is automate this process so that:-
1. The data is filtered copied/pasted into the FilterData sheet.
2. A new workbook is created with the sheets called Log, Report1, Report2 and FilterData with the data from the original file.
3. The new file to be saved with the name from cell C2 of the FilterData sheet.
4. The process to be repeated untill all records have been filtered.
Hope someone can assist this learner?