Link to home
Start Free TrialLog in
Avatar of merv109
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
Avatar of SiddharthRout
SiddharthRout
Flag of India image

What is the logic behind deciding on "Y" or "N"?

Sid
Ok Ok. Got it.

Few moments

Sid
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of merv109
merv109

ASKER

Perfect, exactly what I was after. Thanks!
Avatar of merv109

ASKER

Thanks again!