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?


---
Message posted from http://www.ExcelForum.com/

Why not just automate the copy/paste routine ? (I have discovered that
this is faster than parsing individual cells anyway).

When pasting you only need to supply the top left cell, which in your
case will be the top of the column you wish to remove.


---
Message posted from http://www.ExcelForum.com/

Sorry - I meant *Cut* /Paste.


---
Message posted from http://www.ExcelForum.com/