Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to have a button that, when clicked, will copy the contents of a
specific row and paste it into the next empty row of several subsequent ranges. Example: Range 1: B8:E12 Range 2: B20:E24 Range 3: B32:E36 There is text in B8 and a number in E8. I would like to click a button that will paste the information in B8 and E8 to the first empty rows in Ranges 2 and 3 (could be B20/E20 of Range 1 and B34/E34 of Range 2, and so on, depending on which row is empty in each range). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
empty cell / copy and paste | Excel Programming | |||
Find first empty cell in column J. Copy, paste special, value from | Excel Programming | |||
Copy & Paste to Last Empty Row | Excel Programming | |||
Copy and Paste in the first empty available line. | Excel Programming | |||
macro to copy paste non empty data | Excel Programming |