Thread: Copying Series Across Worksheets

Hey all,

I am in desperate need of help here. I am working on a project for work that will streamline our job and save us hours. But, it will take me hours to create this excel template if I have to type these formulas manually. Basically, I have a multiple worksheet project wherein data that has been input in the first worksheet will be "copied" to certain cells in the following worksheets. So, to give you a mental image, worksheet one has a VERTICAL list of names. Each name needs to go into a cell in a subsequent worksheet. For example, the name in A1 of Worksheet 1 needs to go in A1 of Worksheet 2, the name in A2 of worksheet 1 needs to go into A1 of Worksheet 3, and so forth. I did this initially by COPY> PASTE SPECIAL> PASTE LINK, then I switched to copying and pasting the code from the Paste Link process and changing the cell numbers in that code to match the proper cells from Worksheet 1. The problem is that copying and pasting and then manually changing the cell numbers on hundreds of subsequent worksheets is going to take forever. Any chance there is a way to "Fill Series" this process? Any help is appreciated and I can answer any questions you have.