Software

General discussion

Gravatar
0 Votes
Locked

Maintain link to source workbook cell

By bill ·
I am trying to set up a worksheet that will reference information provided to me in a workbook by someone else. I get it every few weeks from them, with the same name just updated data. Columns stay the same. When I set up my links everything worked fine. Except. Now if they delete a row out it changes the imported link info.

The linked data no longer resides in the same cells in the new source workbook as they did in the old.

Is there some way to use a Access like primary key to make sure I am linking to the correct row of data each time I get a new file. Each row of data has a unique identifier.

Thank you.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Maintain link to source workbook cell

by DKlippert In reply to Maintain link to source w ...

Have you tried named ranges?
Also here are a couple of references to Dynamic ranges. They automatically change the reference based on the layout of the data:

(There are no spaces in the URLs)

www.microsoftexceltraining.com/Excel/DynamicRanges.htm

www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm

gravatar
Collapse -

Maintain link to source workbook cell

by bill In reply to Maintain link to source w ...

Poster rated this answer

gravatar
Collapse -

Maintain link to source workbook cell

by j.a.lawrence In reply to Maintain link to source w ...

I hope you know a little about VBA

You could also take a look at writing a VBA script to get out the info that you need. If the Row or column text heading names stay the same, it shouldn't be too hard to loop thru the info to find the column you need, then bring the data in.

gravatar
Collapse -

Maintain link to source workbook cell

by bill In reply to Maintain link to source w ...

Poster rated this answer

gravatar
Collapse -

Maintain link to source workbook cell

by bill In reply to Maintain link to source w ...

This question was closed by the author

Back to Software Forum

Start or search

Related Discussions

Related Forums