Recent content by NSGuard

Appreciate the help. I was able to manipulate that to what I needed. Thanks again!

I'm looking to make a macro that takes data in column A and seperate it into three columns. I'm able to do it by setting up the macro manually, but is there a way to loop it to do it automatically as long as there is information in column A...

Sorry John, That didn't do exactly what I needed b/c the D5 will not always be a negative number. This is pretty much what I'm looking to do, but all in one statement. ------------------ IF D5>0 Then H5 > D5 Then I5 = E5 or H5 < D5 Then I5 = 0 or H5 = D5 Then I5 = 0 Or IF D5<0 Then H5 >...

I guess I didn't explain it too well did I, haha. A B C D E F G H I 3 Team A 19 -2 ??? 4 at Team B 8/1/06 -7.5 1 21 2 ??? 5 Team C -7.5 1 15 8 ??? 6 at Team D...

Is there a way to have two If Functions running together. The second one is attempting to place an greater than or less than equation into the first If loop based on if a specific cell contains a negative or positive number. ie This is what mycurrent attempt has produced, but doesn't work, the...

Thanks! I will see if this helps at all.

2002

Does anyone have an idea why a movie file won't run on one persons computer but run on anothers. I have a presentation with 4 media clips attached to it, the presentation runs flawlessly on my computer and anothers, but will not run others. I'm dumbfounded. Thanks for any ideas in advance.

Is there a way to take 11 seperate reports and combine them into one continuous report (the reports each have different fields). report1 followed by report2 and then report3, etc all are apart of reportall. The program was originally set up to print off all 11 reports, but the user now wants...

Thanks Duane, That worked perfectly. I really appreciate the help!!

That centers it horizontally, I want to do it vertically like this: ----------------------- john smith abcd lane washington, dc 45642 ----------------------- not this: ----------------------- john smith abcd lane washington, dc 45642 -----------------------

I have a report that prints out 10 Labels to a page and some information doesn't take up the whole Label, so I was wondering if there was a way to vertically center the information so that the whitespace isn't so drastic. You can do it in Excel, but I can't seem to figure out a way to do it in...

Figured it out.. Can Shrink Property in the Detail Section was set to "NO", needed to be "YES". Thanks for the help hneal98

Lines It will Look like this Bob 2034 W st arlington, va 22202 703-656-6456 703-646-6456 Bob@Bob.com ------------------------- Kevin 2034 W st arlington, va 22202 703-656-6456 703-646-6456 Kevin@Kevin.com Instead of Kevin starting just after the break line

No