Excel - linking cells between 2 sheets

By jessica_Gossett ·
I have 2 sheets, sheet 1 look like this:
Col A Col. B
H due date
H due date
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Is this not just a simple link?

by TechBro In reply to Excel - linking cells bet ...

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:


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.

Related Discussions

Related Forums