I am having trouble writing a macro that when I hit a certain button it copies the data in a range and then pastes it to another sheet to the next available row.
For example, I have 2 sheets: Load List & Hardware. In the hardware sheet, I have button that when I click on it, I want it to copy range B5:E5 and then paste it to the Load List sheet to the next available row starting at C11.
I will have multiple buttons that copy different ranges and paste them to the next available row in the Load List sheet.
For example, I have 2 sheets: Load List & Hardware. In the hardware sheet, I have button that when I click on it, I want it to copy range B5:E5 and then paste it to the Load List sheet to the next available row starting at C11.
I will have multiple buttons that copy different ranges and paste them to the next available row in the Load List sheet.