 | Junior Member with 6 posts. THREAD STARTER | | Join Date: Jan 2012 Experience: Beginner | |
Creating a Loop formula Hey Guys,
I'm writing a Macro to grab information from one spreadsheet and present it in a nicer and more printable fashion in another spreadsheet. The original spreadsheet displays Projects, listed down the side, and the information about each project listed across. So a project called Test Project would be in A4, and then all of its information sits in B4 through O4.
I have already written the code to pull the information into the new format on the second sheet, but the original spreadsheet (called a report) will have a varying number of projects on it at any given time. I know I will have to adjust the row number for each copy of the code, but how do I write it so that If there is something in A4, then pump out the code that I've written?
More importantly, how do I write it so that if there is NOTHING in A4, to not write anything at all? |
