C
Cameron Smith
I have a worksheet Called wholesalepricedata.xls that has a list of about
300 rows and 10 columns such as ID, SHU, Product Name, Wholesale Price etc..
I have two other excel files that pull their data from this list.
A price sheet and an order form.
I sort the list by the Product Name column because it is alphabetical and I
use dropdowns in the order form and it's easier to find the product. The
dropdowns link to a cell on the order form and supply the row number that
the product is on. On a separate worksheet on the order form I have the
cells in a row get their data from the main list based on that row provided
by the dropdown.
Using this type of equation:
=INDEX([WholesalePriceData.xls]List!C:C,Selector!D1)
Selector is the sheet on the order form with the dropdown and D1 is the cell
that the dropdown links to giving the row number of the product selected in
the dropdown.
Here is the problem.
When a product is added or deleted from the main list in
wholesalepricedata.xls the reference that the dropdown made does not follow
up or down as is not dynamic. It is just a number that was dumped there when
I made the selection. It just keeps to the row that was originally selected
by the dropdown and the selection in the dropdown itself updates to show the
different product that now occupies that row on the list. Is this just the
way dropdowns work? Am I using them in a way that I shouldn't be?
Is there a way to make a dropdown track it's selection and stick with it as
it moves up and down the rows in a list so that say I originally selected
apples and they were on row 20 in my list. Then I added rows to the list and
resorted it. Now apples are on row 28 but the dropdown is still pointing to
row 20 in the list which now has oranges
Is there and easier way to make a cell match the contents of a cell in a
column on a list no matter what row it's on?
Thanks,
Cameron
300 rows and 10 columns such as ID, SHU, Product Name, Wholesale Price etc..
I have two other excel files that pull their data from this list.
A price sheet and an order form.
I sort the list by the Product Name column because it is alphabetical and I
use dropdowns in the order form and it's easier to find the product. The
dropdowns link to a cell on the order form and supply the row number that
the product is on. On a separate worksheet on the order form I have the
cells in a row get their data from the main list based on that row provided
by the dropdown.
Using this type of equation:
=INDEX([WholesalePriceData.xls]List!C:C,Selector!D1)
Selector is the sheet on the order form with the dropdown and D1 is the cell
that the dropdown links to giving the row number of the product selected in
the dropdown.
Here is the problem.
When a product is added or deleted from the main list in
wholesalepricedata.xls the reference that the dropdown made does not follow
up or down as is not dynamic. It is just a number that was dumped there when
I made the selection. It just keeps to the row that was originally selected
by the dropdown and the selection in the dropdown itself updates to show the
different product that now occupies that row on the list. Is this just the
way dropdowns work? Am I using them in a way that I shouldn't be?
Is there a way to make a dropdown track it's selection and stick with it as
it moves up and down the rows in a list so that say I originally selected
apples and they were on row 20 in my list. Then I added rows to the list and
resorted it. Now apples are on row 28 but the dropdown is still pointing to
row 20 in the list which now has oranges
Is there and easier way to make a cell match the contents of a cell in a
column on a list no matter what row it's on?
Thanks,
Cameron