Hi guys, first time poster so I hope you can help. I seldom use Excel anymore as I prefer to use Access for large quantity of data.
I have a spreadsheet I need some help with. this has columns begining with A to S (with data in it)
It has rows begining on row 5 and goes down to 85 but it gets bigger every day.
I want to create a macro with several phases
Phase 1 - Select the rows I specify, ie pop up box to decide on the rows
Phase 2 - Filter down and select the rows in this selection where coulmn K has a value (unselecting the rest)
Phase 3 - Copying Coulmns A, B, D, E, F, K, from the selection
Phase 4 - Pasting these coulmns into A, B, C, D, E, F, of the sheet the macro sits on
I hope this makes sense.
Bookmarks