How to refer to changing data in excel?

Question

can you please help me maybe with basic question about refering to changing data in excel on the other sheet? The thing is: I have a vlookup in Sheet 2 and in the Sheet 1 I import data from txt.

For every new instance I delete data in Sheet 1 and import new data to the same sheet. After I do this - Excel stops to work and shows error in reference, because the data is previous data is missing. But I want to preserve the same references such as A1, B2, etc. together with new imported data.

Thank you for your help. Barbora

Sorry, for misunderstanding - I only clear it. Butthe references are not kept. — HeadOverFeet
– HeadOverFeet, Commented Oct 30, 2015 at 11:59
gotcha, do you delete rows / columns? or only cell contents? are you using VBA? — WhiteHat
– WhiteHat, Commented Oct 30, 2015 at 12:01
Well, I delete them and the import another data. Do you think that only emptying them would help? — HeadOverFeet
– HeadOverFeet, Commented Oct 30, 2015 at 12:06
Yes! it helped! Thank you, I knew it would be a tricky small bastard :D Thanky you a lot! — HeadOverFeet
– HeadOverFeet, Commented Oct 30, 2015 at 12:12

WhiteHat · Accepted Answer · 2015-10-30 12:17:52Z

1

To avoid creating reference errors, clear the contents of the cells, rather than deleting the actual rows, columns, and / or cells...

answered Oct 30, 2015 at 12:17

WhiteHat

61.3k7 gold badges54 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to refer to changing data in excel?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related