Hey all
I have recently just began delving into programming, i have a task comming up which requires me to format and extract data from roughly 50 Excel files (fun fun fun)
Its nothing hard, just really teadious. Here is what i need to do in the files:
1) Go to Sheet named "Content Plan" (Always the same name)
2) Unhide ALL columns
3) Select all rows from Row 7 onwards (this Row can vary depending who i got the excel from, sometimes its row 4,5,6,7)
4)Copy all selected content
5)Create new Sheet and name it "Import"
6)Paste copied content in A-1
7)Apply Filters to all columns
8)Filter out all Blanks from column "F" (Always column F)
9)Save the file with the same name in same folder but add on "-For import" to the end of file name
I have a deadline for this and would ideally like to learn for myself but i dont have the time, so i was hoping someone could help me out and create the macro for me as best as you can? Im not sure how much of this can be put into 1 macro so any help would be greatly appreciated!!formation.
Thanks in advance
Ali
Bookmarks