Software

Ask something
Question Locked

Excel - linking cells between 2 sheets

0 helpful
2 replies

by jessica_gossett

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have 2 sheets, sheet 1 look like this:
Col A Col. B
H due date
G
V
T
H due date
G
V
Sheet 2 has dates
row 1: 010207
row 2: 020307
I would like sheet 2 date data populated to sheet 1 where the cell says due date automatically when data paste to sheet2. Data size for sheet 2 will be 2K lines.

Any good idea w/o link cell by cell for a template? Thank you!

2 replies

by techbro

Maybe I don't fully understand the question, but isn;t this just a link from sheet1 to sheet2? The celles on Sheet1 would read something like:

=Sheet2!B2

Then do a FillDown on sheet1 to make sure all of the cells are linked properly.

If you email a sample to me, I can probably make an example sheet for you faster than I can explain it.

This discussion is closed to new replies.