Combine 1 cell with multiple cells

[Phlip183]

I wanted to know how to write a script so it would Concatenate a value in 1 cell that is fixed, and multiple submissions in another column such as:

A1: Sample

B1: 1
B2: 2
B3: 3

C1: Sample 1
C2: Sample 2
C3: Sample 3

Thanks.

 

[Phlip183]

Thank you very much for all your help...
The data sheet fits in to the script by providing a location for the New submission entries to go in. So i have a find command on a key word that is in the data sheet, have it insert a row(s) above the key word in the data sheet and Then i have a count function that counts how many entries there are in the New Submission sheet so it can insert that many of rows in the data sheet.

By the way Rick Rothstein, It performs and error on this line:

[Submit.Range("B1").Value = "=""" & Info.Range("A1").Value & " ""&" & Mid(Submit.Range("B1").Formula, 2)]

 

[Rick Rothstein]

By the way Rick Rothstein, It performs and error on this line:

[Submit.Range("B1").Value = "=""" & Info.Range("A1").Value & " ""&" & Mid(Submit.Range("B1").Formula, 2)]

Just so you know, the code worked without error using the made-up data I worked with. So, can you tell me the error you get and also can you post the formula you have in B1 on your New Submission sheet (so I can test with it directly)?

 

[Phlip183]

Yup, you were right... I was able to figure it out... Thank you very much every1 for your help!