Concatenate but only to Certain Cells

Hello,

I have an INI file that im trying to reformat. On Sheet 1 is the current structure of the ini file. I've trying to reformat the variables and to add the name found on the cell in Group Names. I've tried to filter out the cells based on the criteria i need but when i do Autofill to the last cell available on column A it concatenates to the empty rows an the rows that are comments or sections.

The expected outcome sheet shows how it should look once the macro is done. The format of the variables from #{Test} to {{ Test.Server1 }}. If the original variable has a "." in the name already it gets replaced with "_" as shown on line 6. The comments and the sections do not get anything done to them.

The Group Names page can vary from 3 to 9 names just depending on the project. But you can see the expected outcome should have a separate column with each Name provided.

Any suggestions on how to accomplish this?Concatenate Example.xlsx

Hello,

a bit cumbersome … So Sheet1 column A should be corrected for efficiency …

Rather than the expected worksheet why not creating directly the .ini file ? (needing an attachment for this expected .ini file …)

Thanks for the reply. I updated the sheet to have sheet 1 already formatted without the group names Concatenated. I have over 200 files im looking to format and generate with the new format shown on the expected outcome. A file generated would be the ideal solution one for each group name found on the list. Concatenate Example (1).xlsxOutcome.txt

According to your last attachment, once Sheet1 column A correctly updated - as A2:A3 must be {{ Test.# }} -
a VBA demonstration as a beginner starter :

PHP Code: 

Sub Demo1()
    Dim F%, S$, V
        F = FreeFile
    With Application
        S = Join$(.Transpose(Sheets(1).UsedRange.Columns(1)), vbCrLf)
    For Each V In ['Group Names'!A1].CurrentRegion.Value
        Open ThisWorkbook.Path & .PathSeparator & V & " .ini" For Output As #F
        Print #F, Replace(S, "#", V);
        Close #F
    Next
    End With
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

So its generating the file and naming it based on the group names but it's not Concatenating the group names to the variable. As shown in the outcome.txt file above.

Your bad as it works as expected on my side !

As I wrote « once Sheet1 column A correctly updated - as A2:A3 must be » … so well read my previous post
then correct at least Sheet1, concatenating operates according to # character …

Wow!! totally misread that.. Thank you Marc..works perfectly!