Hi

I need to carry stock over from one sheet to another sheet in the same file.

eg.
s/sheet "Stock Req 3-8 Digit BarCodes" , column A, that has quantities in column V

and

s/sheet "Stock Req 3-8 Digit BarCodes" , column A, that has quantities in column W


The thing is, I dont want it to leave gaps between the recorded information. e.g

http://www.epping.co.za/excelhelpneeded.html

I am sure this must be a simple thing for you guys,
Help on this will be much appreciated.

Regards
Sonar