I have code to ask the user "Type in the date", I need code to find that date, Copy that active cell on the excel spreadsheet along with three cells directly below for example: if G6 is selected as the active cell, I also need G7,G8,and G9 copied to a new spread sheet. This active cell will change with every different user. Can anyone help? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Selecting cells to be moved to a new spreadsheet
- Thread starter gjsala
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Solved