merv109
asked on
concatenating excel cells with a loop
Hey folks,
I have a workbook with 2 sheets, sheet1 is the "input" and sheet2 is the "output". basically, I'm trying to find a way to derive the sheet2 output from the sheet1 input using a macro.
Essentially, the input sheet is the raw data, the output sheet is creating the skus for something else. The skus created are a combination of cells A+B+ the title and the value for c-n (this'll make more sense by looking at the sample output)
Any help greatly appreciated.
Copy-of-sample-input-1.xls
I have a workbook with 2 sheets, sheet1 is the "input" and sheet2 is the "output". basically, I'm trying to find a way to derive the sheet2 output from the sheet1 input using a macro.
Essentially, the input sheet is the raw data, the output sheet is creating the skus for something else. The skus created are a combination of cells A+B+ the title and the value for c-n (this'll make more sense by looking at the sample output)
Any help greatly appreciated.
Copy-of-sample-input-1.xls
Ok Ok. Got it.
Few moments
Sid
Few moments
Sid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect, exactly what I was after. Thanks!
ASKER
Thanks again!
Sid