Data transfer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have 2 worksheets and when i have input on sheet 1, i want to same input to
be copied to sheet 2 automatically. anyone have any idea how to do that?
 
One method is to select the cell you want it copied to and enter = sign in
the formula bar then change sheets while still in the formula bar to the
source sheet and click on the required cell and then press enter.

Another method is to copy the cell in the first sheet and then select the
second sheet and select the cell that you want it copied to and right click
and select paste special, paste link (bottom left of dialog box).

Another way if it is a one off and you don't want to do it as above with
links, you can select both sheets by holding the Ctrl key while you select
the second one. Any changes made to the first sheet are reflected in the
second one.

Regards,

OssieMac
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
autocalculate doesn't work even with formula . 1
Inputting data into two worksheets 3
VBA to automatically cut, paste entire row based on date input and delete row 0
Look up in another sheet for values to return in 1st worksheet 2
worksheet renames - specific 0
copying row 2
cells linked from worksheet to worksheet 1

Back
Top