Drag number 1 sheet to another sheet.

Hi,

I am trying to drag drag number with specific quantity from one sheet to another sheet,
1) There is item name in col C ,start number in Col D and dragging qty in col F
2) i want start 1 item drag in sheet 2 with quantity in sheet 2 col D.

The data is near about 20 lack so is it possible with Macro code or any formula.
any help really appreciate.

I have attached sample workbook with input and output result.

Maybe something like:

Please Login or Register  to view this content.

test it on a copy of your input sheet.

Yes ragulduy this is what i want.

Thaknku very much have Good Day

one little confusion if start serial Len is 18 now when i run macro whole sheet displaying =r[-1]c+1 formula. pls help

Can you post an example workbook for which it does not work?

Here is the example.

I don't get a problem with the whole column being filled but I think there is an issue with the numbers being too long to handle arithmetically.

I'd guess you would need to change the formula to something like:
.FormulaR1C1 = "=LEFT(r[-1]c+1,10)&RIGHT(r[-1]c+1,LEN(r[-1]c)-10)+1"

So that you only operate on a smaller portion of the number and then append the start to it.

No not working i have attached workbook.

Please Login or Register  to view this content.

How about that one?

Originally Posted by ragulduy

Please Login or Register  to view this content.

How about that one?

Perfect ****
Thank you very much
cheers

Originally Posted by ragulduy

Please Login or Register  to view this content.

How about that one?

Perfect ****
Thank you very much
cheers