I have one sheet of data (1500+ rows) which is added in a non-sequential order which I need to keep in non-sequential order.
But I would like to have another worksheet in sequential order.
Is there any way to link the second worksheet to the first without individually pasting links?
Thanks in advance.
i'd use autofilter
Is there any reason you cannot simply have a copy of the data in the second sheet?
How often does the second sheet need to be "updated"?
(ie are you wanting to refer to it all the time or infrequently?)
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
I think that's what I'm going to have to do.
I thought there might be an elegant way to do it!
The non sequential sheet is updated frequently (and is a shared document) - and it would be helpful to see the updated sequential sheet weekly.
Will go with your suggestions,
Thanks.
Here is a simple macro - runs with {CTRL} t in attached workbook
Takes data in sheet "NonSequential" and copies it to sheet "Copy", then sorts on Column B
Data range is set as the current region starting at cell A1 - so assumes that there are no empty rows or empty columns
(empty cells are not a problem)
Please Login or Register to view this content.
Last edited by kev_; 07-20-2017 at 10:01 AM.
Ooo very exciting! Thank you. Will have a play around with it tomorrow!
Much obliged.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks