Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

link data within worksheets

link data within worksheets

link data within worksheets

I would like to have two worksheets, I'll call them A and B, within a workbook. I would like worksheet B to display only certain data or cells from worksheet A. The goal is to be able to use worksheet A for my estimating work, and have only those values which I want the customer to see automatically displayed on worksheet B. This way I can just print or email worksheet B to a customer at any time without letting them see everything on worksheet A.

I know how to link cells and copy formatting from one worksheet to the next. What I am having problems with is setting it up such that worksheet B automatically updates to display the information from worksheet A if I add additional rows to the information. So, is it possible to link a range of cells from one worksheet to another and when I add a row to that range on Worksheet A, a new row is also added and linked on worksheet B? Confusing, I know, hopefully I have adequately described what I want to accomplish. Thanks.

RE: link data within worksheets

confusing, not really.

try using the excel offset function along with range names.  while i cannot recollect the website, there is an excellent example provided for using the offset function.
i learned of it and use for monitoring vehicle mpg data (i.e. chart is automatically updated once data is entered - NO need to constantly modify chart).  i'm referring to only 1 example, but it can be expaned to accomplish others.
try checking the "ozgrid.com" website for excel, the j-walk.com website, or links from within the j-walk.com website.
i'd be willing to share the reference mpg workbook, if that will assist you in using the offset function.  please advise.
good luck!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close