×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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!
  • Students Click Here

*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

Jobs

identical sheets where copies update

identical sheets where copies update

identical sheets where copies update

(OP)
I'm just curious if there's a way to set up a set of sheets to mirror a "master" and always update their data if data in the "master" has been changed.

going one step further, I have sevral sheets that all represent the same data but they present the data with different sort variables so i can just go from one sheet to another instead of sorting the same sheet different times.

ideally, I would like to enter data into one master list and have the other sheets reference this master but still be sorted on the appropriate variable.

I've got a work around right now where I use some macros to basically automate a cut and paste of the master data into each sheet and then sort on the variable.  while it's automated, it was kind of tedious to set up and I'd rather not reproduce that effort on other spreadsheets that require similiar data input and manipulation.

thanks

RE: identical sheets where copies update

You can reference a cell value from one workbook to another directly:

=[myfile.xls]Sheet3!$J$3

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

RE: identical sheets where copies update

Yes, I agree with johnwm, the easy part is getting data linked from one spreadsheet to another spreadsheet.

The tough part is the sorting part.  If there were a function like sort(block1,column2) which returned a sorted block you would be in business.  I don't remember any such function although I'm sure the vba wizards have built on in some of the available excel add-ons.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: identical sheets where copies update

You might be able to use Custom Views and assign macro keys to switch between them, showing different sorts and filters.

RE: identical sheets where copies update

(OP)
thanks for the suggestions.

I think I can simplify my workaround so that it is adaptable to a more general case based on your suggestions.  It will still require a macro to perform the sort but it should be a simpler implementation than what I have now.

Michael

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!


Resources