Automatic transfers

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

Guest

Is there a way to have (i.e.) column B in sheet 1 to transfer automatically
to column B in sheet 2?
 
Terri

Select B1 in sheet2.

Enter an = sign.

Switch to sheet1 B1 and hit ENTER key.

Drag/copy sheet2 B1 down as far as you have data in sheet1 column B

Alternative..........

Select sheet1 B1 then hit SHIFT + End + Downarrow

Copy.

Switch to sheet2 B1.

Edit>Paste Special>Paste Link>OK>Esc.


Gord Dibben Excel MVP
 
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

VBA to automatically cut, paste entire row based on date input and delete row 0
Which is the best MBOX Converter Tool different formats conversion? 5
Vlookup & relative cell reference? 2
Need VLOOKUP to Work Two Ways 0
SUMIF or SUMIFS help 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Criteria to return maximum value where x = x 3

Back
Top