Help for a newbie!!

[jakedemus]

I've just signed up and i hope somebody can help me out.

I'm tryin to write a macro that will:
- find the condition columns in a spreadsheet (their headings are coloured light turquoise)
- check if each is populated
- if it is then copy each individual cell's info and the column name,(e.g. Type, OS etc.) and concat in another cell in that row where the column is called "Field" and is coloured yellow

hope i was some way clear.
any help would be greatly appreciated!!!

 

[SteveO59L]

Welcome to the Board.

You might get a better response if you posted a sample of your data and what you would like to do with it.

 

[jakedemus]

A1 FIELDS (col name, cell coloured yellow)
A2 Type | Colour

B1 FIELDS ++ (col name, cell coloured yellow)
B2 Type == 2352 AND Colour == 'Blue'

C1 TYPE (col name, cell coloured light turquoise)
C2 ==2352

D1 COLOUR (col name, cell coloured light turquoise)
D2 == 'Blue'

If TYPE and COLOUR cols are populated the col name is copied into FIELDS and the col name and info is copied into FIELDS ++

Don't know how many rows or columns will be in the spreadsheet.
Just beginning to learn macros so thanks for any reply or comments.