formulas

V

VancouverLady

Scenario:

I have a workbook that has multiple worksheets. These worksheets are linked
so that data is entered into one and feeds to the others. When I add a line,
the formulas get messed up. How do I prevent this.

Also, I have to send these spreadsheets to e-mail recipents, who have the
same issue...when they open the spreadsheet the data is all messed up because
the formulas don't stay constant.

Any info anyone can give me would be most appreciated
 
J

Jacob Skaria

Without seeing the data or the formulas it would be difficult. Check out help
on VLOOKUP() which may help you to change the formulas to pick information
dynamically.

If this post helps click Yes
 

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

Top