Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Search Search
Search for:
Tech Support Guy > > >

Creating a Loop formula


(!)

Seeseman4's Avatar
Seeseman4 Seeseman4 is offline
Computer Specs
Junior Member with 6 posts.
THREAD STARTER
 
Join Date: Jan 2012
Experience: Beginner
05-Jan-2012, 09:36 AM #1
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?
Seeseman4's Avatar
Seeseman4 Seeseman4 is offline
Computer Specs
Junior Member with 6 posts.
THREAD STARTER
 
Join Date: Jan 2012
Experience: Beginner
05-Jan-2012, 11:08 AM #2
I want to use a DoWhile statement, but I don't know how to have it check all of the A(x) in the series and stop when it hits an empty one.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
excel, formula

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑