Carying Forward data with specific information

[sonar]

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

[Morrigan]

Assuming row 1 is header, in sheet "Short":

A2 = INDEX('Stock Req 3-8 Digit BarCodes'!$A$1:$W$5,SUMPRODUCT(SMALL(ROW('Stock Req 3-8 Digit BarCodes'!$2:$5)*('Stock Req 3-8 Digit BarCodes'!$V$2:$V$5>0),ROW()-1+COUNTBLANK('Stock Req 3-8 Digit BarCodes'!$V$2:$V$5))),COLUMN()) (Copy across and down)

I've also included a sample.

Hope it helps.

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

[sonar]

Thank you very much for the help, I will play around with the sample tonight.

Regards
Sonar

[sonar]

Hi

Sorry, I had a look at the formulas and tried to reproduce it, but with no success. It might be because I dont fully understand what it's functions do. I have included my file so that you can open it and have a look at it,

If you could help me with a formula to just paste the barcodes into short, that has figures in the V column of 13digit barcode spreadsheet (without leaving the gaps and the #NUM errors when it reaches the last one), I would appreciate it. I will then use vlookup/sumif to do the rest. If that ok. I will try and take it from there.

stocktest.zip

Thanks
Regards
Sonar

[sonar]

Hi Morrigan

Can you still help?

Regads
Antoinette

[Morrigan]

I have downloaded your file but have not had much time to look at it. I do not have Excel at home and can only look at it at work. However work is a little busy. I'll see what I can do.

Hi Morrigan

Can you still help?

Regads
Antoinette