I'm trying to create a macro in Excel that will copy data from a couple of cells (if another cell is equal to true) and paste the copied data into the first blank cell in another sheet.
So basically (because I'm sure the above isn't very clear!), if cell K16 is equal to true, copy cells B16 and C16 (from sheet "SALES") to the first blank cell in column A on the sheet called planning. The macro would go down column k until it checked all the values.
The copying part isn't what I'm struggling with. I'm having a hard time consistently getting the data into the first blank cell all the time.
Does anyone have any suggestions?
Thanks in advance!
Heather
So basically (because I'm sure the above isn't very clear!), if cell K16 is equal to true, copy cells B16 and C16 (from sheet "SALES") to the first blank cell in column A on the sheet called planning. The macro would go down column k until it checked all the values.
The copying part isn't what I'm struggling with. I'm having a hard time consistently getting the data into the first blank cell all the time.
Does anyone have any suggestions?
Thanks in advance!
Heather