array / vb problems
Ok brainboxes, get your laughing gear round this
I have two sheets displaying the same info but in a different order.
The fields are:-
drop no : drop id: location : keys : pod (x 12 rows)
Sheet 1 needs to be ordered by drop id
Sheet 2 needs to be ordered by drop no.
Drop id's are unique but locations are not.
What do ya think?
Any comments appreciated
Thankyou
There is no sample data in your example workbook.
There is no specific question or problem I can spot. What's the problem?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
My apologies
it was late, i was tired, and i wasnt originally gonna put the whole wporkbook on the site.
The run listing sheet has 9 runs on it.
Each of those runs neeeds to be on its corresponding sheet
i.e. run 1 needs to be on sheet 1 etc.
Hope this makes a little more sense now.
Thankyou for replying.
Colin
Also,while i remember.
if you look at run 1 you will see that there is in fact 2 runs (LM & LK) that have been joined to make 1 run but listed separately to make it easier for the loaders to read. On the sheet 1, they need to be in drop order, the fact that they are / were separate runs is irrellevant. empty cells need to be ignored.
Hope this makes sense.
Good luck.
Colin
No problem. I see that now. Take a look now. This allows you to list the Drops on the Run Listing for each run in any order, like you jumbled them on Run1. Having them in order is fine, but not necessary. The individual run sheets will put them back in order for you.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thankyou so much, i looked at vlookup but didnt think it was what i needed. Simple when you know how.
Thanks again
colin
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks