How to use a macro or formula to copy data from cell to all cells in that group in adjacent column
Requirement:
In the file the name of every person is in the cell right below the cell with "(Unaudited)" (See column A below).
The user would like to do is to add the name of the person in all cells up to the next "(Unaudited)" in column B (see column B below).
Solution:
In B7 use this formula:
=IF(A7="(Unaudited)","",IF(A5="(Unaudited)",A6,B6))
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to run a macro if a column has a certain text in it |
| How to end a macro if cell blank or continue if populated |
| How to use a macro to copy data from multiple workbooks to one master sheet in another workbook |
| How to use a macro to copy data from multiple workbooks to one master sheet in another workbook |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
