Helpfulbox Now Offers Free POS Software for restaurants, kiosk, and any other retails business completely free used windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, al for free.

excel 2000 listbox edit help please... This shoudl be easy but darned if i can find it. I have a spreadsheet where row 1's columns A to C have the values 1, 2 & 3 respectively. Column D is a listbox, and the values in the dropdown list are the values from the preceeding columns. I copy row 1 to row 2 and change the values of column A, B & C to 7, 8 & 9. But the listbox in column D displays the values from row one and didn't adjust to display row 2 's values. How do i edit where the listbox on row 2 points? Darned if i can find it. Thanks! Donk.

By: Guest
Date: Unknown--
Response
0
Data, Validation, Settings

...but if you change the Source to be Relative instead of Absolute (remove the $ signs) you can copy &paste into the cells below without having to change them...

[d] By: Guest
Date: unknown---
Response
0
When you create the list box, you will notice

that the source is: =$A$1:$C$1

Dollar signs make them absolutes, so when copied they remain the same.

Change it too: =A1:C1

[d] By: Guest
Date: unknown---
Response
What is 1 + 100



Helpfulbox Now Offers Free POS Software

for restaurants, kiosk, and any other retails business completely free. It can be used as windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, all for free.

Just Updated::