Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate infil of data into a cell on subsequent worksheets.
I have sheet One.
Sheet one, amongst other info, has a list of reference numbers in Column A. I want to generate a load of other individual sheets in the workbook that subsequently reference the values in column in Sheet 1. EG. On Sheet 1 A1 = Ref No1 A2 = Ref No2 A3 = Ref No3 A4 = Ref No4 --------- All other sheets are templates with identical layout How can I quickly populate all the values in Cell A1, on sheets 2 onwards such that: Sheet 2 A1 = Value in Sheet1, CellA1 Sheet 3 A1 = Value in Sheet1, CellA2 Sheet 4 A1 = Value in Sheet1, CellA3 Sheet 5 A1 = Value in Sheet1, CellA4 Sheet 6 A1 = Value in Sheet1, CellA5 Sheet 7 A1 = Value in Sheet1, CellA6 SS. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data links on subsequent worksheets | Excel Worksheet Functions | |||
How can I copy filtered data to subsequent worksheets? | Excel Discussion (Misc queries) | |||
How i have #10 in cell when previous#5 and subsequent #15 | New Users to Excel | |||
Tool fro entering data in subsequent cells | Excel Discussion (Misc queries) | |||
Automate a macros when data in a cell changes (e.g.when using quer | Excel Discussion (Misc queries) |