I have a XL 2002 spreadsheet that is a form of sort where data is input. Ihave the non-data areas protected and the data entry areas are all such thatif the cursor keeps moving to the right the data entry flow works out great.In effect I want to change the users options under TOOLS|Options|Editc...
Comments (3) | Promote | Bookmark
pivot table?Sat, 30 Dec 1899 00:00:00 GMTI have set up an invoice template. I want to save each invoice in two seperate workbooks without having to hit "save as". I want one to go into a folder where I can track payments with the invoice number, and the other to save using name. How can I do this?...
Comments (3) | Promote | Bookmark
Setting default directory prior to GetOpenFilenameSat, 30 Dec 1899 00:00:00 GMTWhen using GetOpenFilename the panel displays files in a particular directory, but I want it to open displaying the files in a sub-directory of that one. I have tried using ChDir to set the default, but it doesn't work (probably because my directory paths are all in UNC form). How can I cha...
Comments (2) | Promote | Bookmark
Macro - to copy duplicate rows to another sheetSat, 30 Dec 1899 00:00:00 GMTHello, I have unsorted data (and needs to stay unsorted, so no autofilters) that I want to copy all duplicate rows into another sheet based on a column value. Example: A B C ... 1 x a a 2 z b b 3 x c c 4 y d d 5 z e e 6 r f f 7 x g g ... Using column A as criteria for duplicates. There are 3 ins...
Comments (2) | Promote | Bookmark
Can you sort a list based on catagory names without useing a custom list?Sat, 30 Dec 1899 00:00:00 GMTCan you sort a list based on catagory names without useing a custom list? Thanks, Bobby...
Comments (2) | Promote | Bookmark
go to far left worksheetSat, 30 Dec 1899 00:00:00 GMTI will be grateful for a piece of code to take me to the furtherest worksheeton the far left (in the base of the workbook where the sheet tabs aredisplayed ie, the furtherest tab on the left) in a workbook with many sheetsmany thankswith kind regardsSpike...
Comments (2) | Promote | Bookmark
LEFT functionSat, 30 Dec 1899 00:00:00 GMTHi , Just a simple problem (I hope). I have a column in an excel spreadsheet which takes the first character of the previous column using LEFT(A1,1). Eg A1 has "3-dice", and therefore column B is "3". The problem is that Excel for some reason doesn't allow me to SUM column B. Its like the n...
Comments (2) | Promote | Bookmark
UPDATED - Referencing named Ranges within a Nested IF formulaSat, 30 Dec 1899 00:00:00 GMTnote - I referred to my ranges as lists. Wasn't sure of the impact, if any, that would have to my data. I went ahead and updated this request. I REALLY appreciate any help on this, as I have limited documentation regarding Excel syntax in formulas. Thanks again. All, I am trying to create a...
Comments (1) | Promote | Bookmark
VLookup Not Picking Up Entire PhraseSat, 30 Dec 1899 00:00:00 GMTI'm using a vertical lookup to pickup project titles. The projectnumbers and titles are in adjacent columns and in ascending order byproject number. The titles are a phrase of two to four words. Whenthe vertical lookup executes it frequently only picks up the last wordor the title instead of...
Comments (1) | Promote | Bookmark
Excel Format Cells Numeric Currency VBASat, 30 Dec 1899 00:00:00 GMTHello,I came across some VBA Code that formats an Excel cell, and I waswondering if anyone can explain to me what the various symbols mean:1) _([$-809]#,000.0_); ([$-809]#,000.0)2) #,##0.0[$p]_);(#,000.0[$p]);#,000.0[$p]_); @_)3) _([$$-409]#,000.0_); ([$$-409]#,000.0)4) [$P-1404]#,#00.0In partic...
Comments (1) | Promote | Bookmark
Vlookup & Conditional FormattingSat, 30 Dec 1899 00:00:00 GMTWhen put in the conditional formatting dialogue box, this formula =VLOOKUP(a1,$b1:$c50,2,FALSE)=1 for box 1 w/color code red, (a1,$b1:$c50,2,FALSE)=2 for box 2 w/color code blue, (a1,$b1:$c50,2,FALSE)=3 for box 3 w/color code green will take 50 state abbreviations (singular occurence only) and c...
Comments (1) | Promote | Bookmark
pop-up calculatorSat, 30 Dec 1899 00:00:00 GMThow do I set up to click on cell and number pad shows up like ms money...
Comments (1) | Promote | Bookmark
Addressing Envelopes using Outlook Addresess BookSat, 30 Dec 1899 00:00:00 GMTHow can I use the addresses in Contacts in Outlook (not OE) to address enevlopes?...
Comments (1) | Promote | Bookmark
VBA Functions acrosss multiple versionSat, 30 Dec 1899 00:00:00 GMTI know that certain VBA functions do not work in older version of Excel(i.e. Round() from 2000). It creates Compile Errors.Does anyone know of a list that describes the VBA functions and whenthey were developed? I want to make it part of a HELP routine I ambuilding for a spreadsheet.Thanks in ad...
Comments (1) | Promote | Bookmark
Macro translate from number to textSat, 30 Dec 1899 00:00:00 GMTHi All,does any one have this macro?Ex : 123 = One hundred and twenty threeThanks so much!Thanh Nguyenthanhnguyenthanhnguyen's Profile: http://www.mcse.ms/member.php?action...o&userid=30502View this thread: http://www.mcse.ms/showthread.php?threadid=526637...
Comments (1) | Promote | Bookmark
Auto complete in Excel (Office) 2003Sat, 30 Dec 1899 00:00:00 GMTIs it possible to increase the *memory* of autocomplete' I notice in the columns that excel will attempt to autocomplete if the text has been used in the last 100 or so cells (i think). What I would like is it to attempt to remember , say, 500 cells back. Is this possible' Have I expla...
Comments (1) | Promote | Bookmark
Date: library not found?Sat, 30 Dec 1899 00:00:00 GMTDoes anybody know why this would generate a compile error: library notfound?Dim MyDateMyDate = Date...
Comments (0) | Promote | Bookmark
Entering Data in 1 Worksheet to appear in a specific format in Sheet 2Sat, 30 Dec 1899 00:00:00 GMTOn the second sheeta1) =Master!A1a2) =Master!A1b1) 100b2) =Master!B1C1) No Sales CreditC2) =Master!C1D1)=-1*Master!D1D2)=Master!D1E1) =Master!E1E2) =Master!E1F1) =-1*Master!F1F2) =Master!F1G1) =Master!G1G2) =Master!G1Regards,Tom Ogilvy"iomighty >" <<iomighty.17anb4@excelforum-nospam.com...
Comments (0) | Promote | Bookmark
Static dates in HeaderSat, 30 Dec 1899 00:00:00 GMTI use &[Date} and function in my Excel 2003 headers. I would like this date to automatically update only when I have made edits to the document, not every time I open it. Also, I would like to have a way of having the previous saved date show up and be updated on the change. Something like this...
Comments (0) | Promote | Bookmark
OLAP Cube for Excel 97?Sat, 30 Dec 1899 00:00:00 GMTHi all,There's an option of getting data source from OLAP cube in Office 2000 orlater application but not in 97 while creating pivot table. May I know ifthere's add-in download available that support this function for Excel 97?Thank you...
How can I use the addresses in Contacts in Outlook (not OE) to address enevlopes?...
I have a XL 2002 spreadsheet that is a form of sort where data is input. Ihave the non-data areas protected and the data entry areas are all such thatif the cursor keeps moving to the right the data entry flow works out great.In effect I want to change the users options under TOOLS|Options|Editc...
I have a spreadsheet I'm using to track the daily sales at a small store. I would like to open it, enter all the sales for the day, and have a running 'year to date' sales total at the end. So it needs to take the YTD total from yesterdays sheet and add it to todays total. I save...
note - I referred to my ranges as lists. Wasn't sure of the impact, if any, that would have to my data. I went ahead and updated this request. I REALLY appreciate any help on this, as I have limited documentation regarding Excel syntax in formulas. Thanks again. All, I am trying to create a...
Hi , Just a simple problem (I hope). I have a column in an excel spreadsheet which takes the first character of the previous column using LEFT(A1,1). Eg A1 has "3-dice", and therefore column B is "3". The problem is that Excel for some reason doesn't allow me to SUM column B. Its like the n...
When using GetOpenFilename the panel displays files in a particular directory, but I want it to open displaying the files in a sub-directory of that one. I have tried using ChDir to set the default, but it doesn't work (probably because my directory paths are all in UNC form). How can I cha...
I'm using a vertical lookup to pickup project titles. The projectnumbers and titles are in adjacent columns and in ascending order byproject number. The titles are a phrase of two to four words. Whenthe vertical lookup executes it frequently only picks up the last wordor the title instead of...
On the second sheeta1) =Master!A1a2) =Master!A1b1) 100b2) =Master!B1C1) No Sales CreditC2) =Master!C1D1)=-1*Master!D1D2)=Master!D1E1) =Master!E1E2) =Master!E1F1) =-1*Master!F1F2) =Master!F1G1) =Master!G1G2) =Master!G1Regards,Tom Ogilvy"iomighty >" <<iomighty.17anb4@excelforum-nospam.com...
I want to highlight a cell based on two conditions: I want to highlight cell A1 if the date in cell A1 is over 14 days older than TODAY() and cell J1 is blank. Joe...
Record a macro when you doData|Filter|Show AllAnd you'll have the code you need.Kigol wrote:> I have code that filters for unique records in place. This works great> but when I try to paste new values into the location which was> filtered, it causes the code to hang. I have determin...