Hey smart people! I'm a novice at macros and have found myself in a little too deep to handle this task with a macro and don't know VBA language to get this done.
I have a spreadsheet with multiple sheets. My macro needs to:
Can anyone help steer me to the best way to conquer this, please?
(Unable to Upload Mini-sheet; says workbook is protect and unable to unprotect it.)
Image shows first line item with 4 lines inserted and images pulled and copied/transposed to new rows below. 2nd line item is started with 4 new rows inserted (nothing else done to it). All items need repeat procedure.
I have a spreadsheet with multiple sheets. My macro needs to:
- Select the main sheet.
- Make task relative.
- drop down 1 line
- Insert 4 lines
- Copy the data from one cell above to the same cells in those 4 new lines
- Copy images (https://...) from Other Sheet over to the main sheet to those new lines into the appropriate cell of the newly inserted lines. Those images are on the one row in 4 cells (4 columns) in the Other Sheet and need to be transposed to the one cell (1 column) in the next 4 lines down and just as values (not formulas).
- then go down to the next line item to set up for the next repetitive motion till all items in the Main Sheet table are completed.
Can anyone help steer me to the best way to conquer this, please?
(Unable to Upload Mini-sheet; says workbook is protect and unable to unprotect it.)
Image shows first line item with 4 lines inserted and images pulled and copied/transposed to new rows below. 2nd line item is started with 4 new rows inserted (nothing else done to it). All items need repeat procedure.