Hello all,
I've recently been given the task of inputting data from a large list into a sort-of master sheet. Currently, the only solution anyone has is to manually enter each number, but I find it hard to believe that there's no way to make Excel do this for us. Unfortunately, I'm no expert. Any help would be greatly appreciated.
A vague example of our master sheet would be as follows:
1
2
4
5
6
7
8
9
11
12
13
14
15
16
18
19
20
We are given data that corresponds to the master as such:
1 1345
2 563
4 435
5 6
8 456
11 456
15 2
16 45
18 5234625
19 2436
20 456
What I want the final product to be:
1 1345
2 563
4 435
5 6
6
7
8 456
9
11 456
12
13
14
15 2
16 45
18 5234625
19 2436
20 456
We can't simply remove row "7" for example, even though there's no data currently, because on a different day there may be data in that row. As well, the master is far from a full list of numbers. They're actually all codes that are numerically sorted, but far from sequential, which is why a few row numbers were skipped in the example.
Also, the actual lists we're working with are about 50x larger, or more. I've experimented with logical if/then formulas, but was only able to populate one cell. When I tried to fill the formula down to subsequent cells, all it gave me was "FALSE."
I apologize if this is a little on the basic side, but I've tried searching the webs to no avail. Thanks in advance for any help I can get!
Bookmarks