Hi,
Could someone help me with a task I am trying to automate?
I have an excel workbook with a list of links on one sheet. The other sheet contains every 25th line coloured green. When I click on a link, it opens in a browser, I will then need to manually copy some text, and paste it on every coloured line (every 25th line) in the 2nd sheet.
Is it possible to create a macro such that after I copy, I need only click a button on sheet 1, or use a shortcut key, so the data will automatically get copied into the coloured line? Also, the next time this is repeated, it needs to paste in the next coloured line incrementally.
If someone could help me out with this, I'd be very grateful. Thanks!
Could someone help me with a task I am trying to automate?
I have an excel workbook with a list of links on one sheet. The other sheet contains every 25th line coloured green. When I click on a link, it opens in a browser, I will then need to manually copy some text, and paste it on every coloured line (every 25th line) in the 2nd sheet.
Is it possible to create a macro such that after I copy, I need only click a button on sheet 1, or use a shortcut key, so the data will automatically get copied into the coloured line? Also, the next time this is repeated, it needs to paste in the next coloured line incrementally.
If someone could help me out with this, I'd be very grateful. Thanks!
