Hi guys,
Hope you can provide some help with vba. Each visible cell in a column will be copied and pasted on every other cell in a column in another sheet. For example, after filtering cells on sheet1, visible cells that will be copied are A3, A10, A14, A19, A27, etc. Each of these visible cells will be pasted one by one on every other cell in sheet2 column B which starts on B1 then B3, B5, B7, B9, and so on. Thank you so much.
Bookmarks