S
scott
I'm trying to think of a way to "sort" or "match" two columns of cells based
on if the values of the rows are equal. For examle, LISTING 1 below shows
cell B2 equal to 196650. I need a way with code to "sort" or "match" that
value with it's equal in column A. So my results would end up looking like
LISTING 2 below, where the 196650 value gets moved to cell B4.
These are bill of laiding codes that will come in each day, so column A's
values would always be increasing as well as column B's billed numbers
would (i.e. cells would be shifting down).
Can someone suggest any functions that may exist that could take the value
of a cell and match it to the correct cell like I described below? I'm
mainly an Access database programmer, but have done a few Excel apps before,
but I just can't get a game plan in my mind on how to come up with a
solution for this problem. Any advice or guidance would be appreciated.
LISTING 1:
BOL BOL Billed
196618 196650
196625
196650
196663 196663
196669
196686 196686
196694 196694
196699 196699
196711
LISTING 2:
BOL BOL Billed
196618
196625
196650 196650
196663 196663
196669
196686 196686
196694 196694
196699 196699
196711
on if the values of the rows are equal. For examle, LISTING 1 below shows
cell B2 equal to 196650. I need a way with code to "sort" or "match" that
value with it's equal in column A. So my results would end up looking like
LISTING 2 below, where the 196650 value gets moved to cell B4.
These are bill of laiding codes that will come in each day, so column A's
values would always be increasing as well as column B's billed numbers
would (i.e. cells would be shifting down).
Can someone suggest any functions that may exist that could take the value
of a cell and match it to the correct cell like I described below? I'm
mainly an Access database programmer, but have done a few Excel apps before,
but I just can't get a game plan in my mind on how to come up with a
solution for this problem. Any advice or guidance would be appreciated.
LISTING 1:
BOL BOL Billed
196618 196650
196625
196650
196663 196663
196669
196686 196686
196694 196694
196699 196699
196711
LISTING 2:
BOL BOL Billed
196618
196625
196650 196650
196663 196663
196669
196686 196686
196694 196694
196699 196699
196711