'Loop copy cell from a range and paste into new worksheets
I'm new to VBA and need some help if possible.
Ok, the task i'm trying to perform seems pretty simple, but trying to figure it out with VBA makes my head hurt ha.
I have a cell range containing dates"A4:A57", in a sheet name "Index". I want to loop through the cell range in my "Index" sheet and copy each cell in turn to cell "A1" for all other worksheets (52 in total).
so i'm copying..
cell A4 value from "Index" sheet to cell A1 of sheet2, then cell A5 value from "Index" sheet to cell A1 of sheet3, and so on for all 52 sheets.
if possible, i'd also like to delete the values from the range after they have been copied across.
hope someone can help
thanks
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
