Auto populate specific data from sheet to another

V_torres 1 Posts Sunday April 22, 2018Registration date April 22, 2018 Last seen - Apr 22, 2018 at 10:33 PM - Latest reply: TrowaD 2395 Posts Sunday September 12, 2010Registration date July 17, 2018 Last seen
- Apr 23, 2018 at 11:56 AM
Hello,

I'm trying to auto populate data from one workbook to another, or sheets if that makes it easier. In the sample I've included I'm trying to take the data on columns "F" and "G" on sheet 1 and make them auto populate in columns "BJ" and "BK" on sheet 2[image:https://img-16.ccm2.net/CGVO_VyAtkr83SFVAfRJFqu53p0=/99ac95ddef9f45db8a8fdacad
84d744a/tmp/15244505522643172536950003061881.jpg|px||center]
See more 

Your reply

1 reply

TrowaD 2395 Posts Sunday September 12, 2010Registration date July 17, 2018 Last seen - Apr 23, 2018 at 11:56 AM
0
Thank you
Hi V_torres,

Seems to me you are asking to link cells, where both cells display the same result.

In BJ4 type an "=", then go to sheet 1 and select F4, then hit Enter to confirm the formula.
Now drag BJ4 1 cell to the right and when the small option box appears, choose the option to apply without format. Now select both BJ4 and BK4 and drag them down as far as needed.

Best regards,
Trowa
Respond to TrowaD