Search results for query: *

Excellent, Thank you Gavin & Brad!! Now I'll try to learn a bit more so I can to "clean up" a couple of other tasks I know I'm doing "the long way.

Thank You. Yes, it will always be sheet 2. I'm trying to find help on the Text function now since your guess was correct, the cells are date format rather than text. I tried it and it will work great once I convert the dates to text.

I use a sheet that must be updated every two weeks. The macro copies the sheet, clears the data ranges, calculates the next pay period dates and renames the sheet to Time Sheet (2). The macro works great for my needs though it probably is not as efficient as it could be but I'm only now trying...

Eugene, I believe Web design software would be the right answer as these are Dynamic HTML (DHTML) effects and are not supported by Word. George

Thanks guys, So far, I haven't convince the client to use the single sheet for chart references. Basically she has one sheet with for data entry and the next 5 sheets extract the info by company to show a chart for each individual data group. Sheet 2 has 3 charts, Sheet 3 has 18, sheet 4 has...

Scenario (and this is the "simplified version." Sheet 1 has the numerical date to be charted: A B 1 Field No. 12 2 HEIGHT ppm (NO3-N) 3 17 20000 4 21 9000 5 29 17000 6 31 7100 7 36 3800 8 37 12000 9 39...

Have you checked to see if you have another "data" file collecting the email? Tools - Options - Mail Setup - Data Files I have four different data files and had the wrong one receiving my mail. George

I use a text box to accomplish same. For Instance, my name, address and email on my resume are in text boxes placed exactly where I want them. You can get to Text Box by turning on your Drawing Toolbar, if you are not familiar with the button on the Standard Toolbar, right click any toolbar...

Sounds like the cell format somehow got changed to Text rather than number or general. The easiest fix is to use Format Painter: Select any cell that works, click the paint brush on the tool bar, Click in the cell with the misbehaving formula; (if the "Entire" Spreadsheet is acting up simply...

Well I'm glad I read your post. I knew about the serial number "dates" but the Integer to Date was new. I'd still be wallowing around trying to sort it out. Thanks for the explantion.

Works Great, now I'll try to figure out how, why & what it does. Appreciate the time!

Ok the scenario is: Column F Class Date (date of next class) Column G Date Books Need to be Ordered (Wed approx, 2 weeks prior to class) So no matter which day of the week the class is on (Mon-Sat); books have to be ordered Wed, two weeks prior. I.E. col F = 2/14/04 col G = should read...

Well, We finally tried again lat night and the error is still there. Synopsis: Network works fine, we could get to any site and her specific site without issue. We could log in and I could navigate with menus but any time I tried to access an HTM page from the site it said DNS error!?! I tried...

I'll call her and see how this works. Many thanks either way as I have added it to my bag of tricks. GeoCan

I have a lady friend who has 5 PCs in her office connected through a router, all work fine and everyone can go weherever they please on the internet with one noticable exception: All PCs can connect to a remote URL but hers. Hers gives a DNS error. I reviewed all the settings in TCP/IP and...

Please, explain what you want to do. It seems to have been truncated. Geo

Dyarwood, Your answer will work Fine since it creates a section break in each instance. A main reason for section breaks is to allow for different formatting; be it portrait/landscape, a different number of columns, or different margins. Geo

Greetings, Just a thought, make sure you use Flag Status instead of Followup Flag from Field chooser.