troubleshooting Question
Fill in a term above certain cells by means of a macro
Andreas Hermle
asked on
asked on
Dear Experts:
I would like to run a macro that performs the following action:
Loop thru all the cells in Column A.
Whenever the macro hits a 1 (i.e. a cell filled with the value 1 in Column A) it should enter 'beginning' just above the cell where the value 1 is found.
Help is much appreciated. I have attached a sample file for your convenience.
Regards, Andreas
Add-Term-Above-Certain-Cells.xls
I would like to run a macro that performs the following action:
Loop thru all the cells in Column A.
Whenever the macro hits a 1 (i.e. a cell filled with the value 1 in Column A) it should enter 'beginning' just above the cell where the value 1 is found.
Help is much appreciated. I have attached a sample file for your convenience.
Regards, Andreas
Add-Term-Above-Certain-Cells.xls
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.