B
brwilson
I use an excel 2000 spreadsheet for tracking product inventory and
customer orders. I am entering orders in 16 columns, (product number
and inventory quantities are in the 1st 2 columns. When I ship an order
I just delete data in the specified column after exicuting code that
removes the ordered quantity from the inventory. Currently I would then
copy the order columns AFTER the cleared column and then paste the data
starting with the column I initially cleared and then clear the data in
the last column containing orders. My problem is that I can't just
delete the column when I ship an order since it affects formula's
elsewhere on the spreadsheet. Is there a way to move this data without
deleting columns?
customer orders. I am entering orders in 16 columns, (product number
and inventory quantities are in the 1st 2 columns. When I ship an order
I just delete data in the specified column after exicuting code that
removes the ordered quantity from the inventory. Currently I would then
copy the order columns AFTER the cleared column and then paste the data
starting with the column I initially cleared and then clear the data in
the last column containing orders. My problem is that I can't just
delete the column when I ship an order since it affects formula's
elsewhere on the spreadsheet. Is there a way to move this data without
deleting columns?