Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different Range Lookups
Hi,
Please Help.... I have 3 sheets with a varying range of data on. These are all indivdually named. I would want to produce a main sheet that combines the 3 into 1. I have a job number column in all 3 ranges that is unique to that range. How can I write some code to copy the job number from range 1 and paste in new sheet and then copy range2 and paste at bottom of range1 in new sheet and copy range 3 and paste at the bottome of range2 in the new sheet? the problem is that each of the 3 ranges have a varying amount of data. My next problem is how could I have a lookup to pull back data against the job number column looking at either of the ranges? How is the best way to do this?? Thanks, Jez |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookups and ifs! | Excel Worksheet Functions | |||
Lookups | Excel Discussion (Misc queries) | |||
V Lookups | Excel Discussion (Misc queries) | |||
Lookups | Excel Worksheet Functions | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |