View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B

Say your data in worksheet 1 starts in A2. In worksheet 2, cell A2, enter
an equal sign. Then select worksheet 1 and click on cell A2. Hit Enter.
In worksheet 2, select A2 and drag that formula down with the fill handle as
far as you need to. Repeat all this for column B. There are other ways if,
for some reason, you don't want the above. HTH Otto
"KnightBall" wrote in message
...
On Worksheet 1 named Transfer settings I have a table called
"transfer_settings". Column A is "Transfer Name" and Column B is "Item #"

I would like Worksheet 2 Called "Event Fullfillment" to have Columns A & B
always equal the columns A&B in the table on worksheet 1.

Is there a function for this
--
Thanks
KnightBall