Hello I know next to nothing about VBA code and would really appreciate some help.
I would like to know if it is possible to add the text of one cell (for example a name in cell B2) to the beginning of a range of other cells (for example C2 to G2) if those cells have a value entered in them.
I would like to do this for rows 2 to 10, placing the text from the B column of that row at the front of the cells in that same row (cells C-G)
Thanks so much to anyone willing to help me out.
I would like to know if it is possible to add the text of one cell (for example a name in cell B2) to the beginning of a range of other cells (for example C2 to G2) if those cells have a value entered in them.
I would like to do this for rows 2 to 10, placing the text from the B column of that row at the front of the cells in that same row (cells C-G)
A | B | C | D | E | F | G |
---|---|---|---|---|---|---|
Joe | 1230 | 1200 | 1200 | |||
Mary | 830 | 845 | 830 | 845 | 845 | |
John | 845 | 950 | 950 | 950 | ||
When I run the macro, I would like it to change to: | ||||||
Joe | Joe1230 | Joe1200 | Joe1200 | |||
Mary | Mary830 | Mary845 | Mary830 | Mary845 | Mary845 | |
John | John845 | John950 | John950 | John950 |
Thanks so much to anyone willing to help me out.