We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

concatenating excel cells with a loop

merv109
merv109 asked
on
Medium Priority
274 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

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

Sid
Ok Ok. Got it.

Few moments

Sid
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Perfect, exactly what I was after. Thanks!

Author

Commented:
Thanks again!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.