Search results for query: *

I have to add rounding to one VLOOKUP in a complicated formula in a price-determination worksheet and copy it to 4000 non-consecutive rows. When I do this, it takes approx. 25 seconds per cell, estimating 24 hours for all. Is there a better way? I can't use search-and-replace because of the...

If I use SUMIF or CountIF formulas then paste to the 20 cells in a filtered list, it takes 5 minutes (I've timed it with a stopwatch) and one of my dual CPUs is pegged the whole time. I have turned off auto-calculation and it makes no difference. As far as I can tell, it seems to be taking...

I am making a form for the sales team. I have a drop down to select a product. With a macro attached to a button, the macro filters an item list based on the selected product. (Similar to this thread as a start point:http://www.tek-tips.com/viewthread.cfm?qid=1632093) The form is locked, but...

We have a file created in Excel 2003 and now edited in 2007 in which the creators put all text in Comments attached to each cell and NOT in the cell itself as text. How, oh, how, can I export these comments? (2500 rows of data's worth >sigh<) I have tried writing a macro to copy them out and...

I think this is close to what was in thread "thread68-1595108", but not quite. I have a work page from which 3 different people are assigned orders to fill and, as they complete them, they enter the text result of its status - "D" for done, "M" for missing or "H" for hold. I want to summarize...

I have a sheet with totals per month, and I need the sum of the last three for use in another trending formula. What formula can I use so I don't have to manually update the formula each month? Jan 15 Feb 5 Mar 6 April 9 May June July 3-Month Total: In April, this would be...

I would like to insert the file name in my adobe 5.0 doc. Actually, I have 120 documents and I'd like to insert it either in the header or footer area of them all. How do I do this? Thanks. TechGoddess :-D

So the webpage is Http://www.techgoddess.com/importantpage.aspx?ID=XX where the XX is an ID from a SQL db because the page posts data for a specific record. Using Vlookup, how do I return the XX into the hyperlink? If I use the Vlookup, I can't get the quotes and the bracket in the right...

If I highlight a field in Word 2002 SP2,like a page number or bookmark, it automatically hits the ALT key, so the File menu is highlighted. For a keyboard junkie, this means I must either hitting ALT twice or use the mouse each time I try to cut & paste. I have the company Symantec...

I create bookmarks at the top of the document and cross-reference to those bookmarks in text in tables throughout the document. When highlighting a field or cross-reference to copy, whether individually or as the whole row of the table, ALT is pressed so now the File menu is highlighted. I...

Using Office XP and Adobe Writer & Distiller 5.0. Taking a one-page Word doc that has text, an eight-row, eight-column table and an inserted .bmp (which is in a text box) and converting to PDF. PDF loses the image - sometimes. It actually flashes sometimes, then disappears. Thinking it's a...

I have a user that wants eight staff members to report to both of two managers who, in turn, report to the CEO. (I'm in IS, so it's not up to me to determine HOW the business is run) However, how can you do this with Visio Organization Chart tools? It is set up to be one-to-one relationship...