Summary: If I'm understanding you correctly, and if you have Access, you could perform the task in that. AND........ Import your already existing excel spread...
Summary: Hi, I would really appreciate if someone could help me with the following problem: Here is what I have: Two different files in Excel 2000; Each file c...
Summary: Ok I am kind of new to this site and have been trying to figure this out for a while... I need to sort a worksheet in a workbook by the acount number ...
Summary: On my spread sheet i want a certain value in a column to cause the entire row to be colored. for example if column T = "word" then the row is colored ...
Summary: hi all, sorry, if my thread in wrong place i have 1 formula in my CR 8 like this if left(ToText({tbsubledger.subledgerdate}),4)=ToText({tblpercentage....
Summary: I am setting up a database of invoices to pass on to a colleague at work. I am looking for a formula in Excel 2003 that will replace part of a set, re...
Summary: Need help with formula: Example: If you have a product that is priced by the hundreds, I would put the letter "M" in cell next to the price and a f...
Summary: Hi, I am looking to forecast fraud levels for personal loans over the next twelve months using excel. I have data of losses occurred in th epast twelv...
Summary: Hi all I have two databases in works 2000 that I want to convert to access 97. The first has 16,000 + entries and after copying to excel, the conversi...
Summary: Is it possible to do this... In sheet1 I have A1 to A1000 - numbers B1 to B1000 - product name In sheet2 In cells A1....A1000 I want to manualy input ...
Summary: I want to update the changed data in a sheet which is linked to individual sheets created in excel but its not possible once the updated sheet is open...
Summary: Hi Does anyone have a code for searching for 4-5 keywords within columns in a single excel worksheet then returning the list of matching rows, ordere...
Summary: I need to have interactive reporting system, i tried to use crystal reports but the system can not give me interactive reports. when you need another ...
Summary: Hi Many times, I have converted PDF file to Excel table with saving as text and opening in Excel. I have a table with 7 columns on paper now that got ...
Summary: PLEASE! help me! I am doing a lab and it is due tomorow and have not been going to class so i'm a bit lost! Anyways, In excel I have defined 8 diff...
Summary: ok, in excel i know there's a feature called FIND (Main menu ->Edit->find) which helps one locate words/features in the datasheet. but my question is...
Summary: I want to be able to export a table in access to excel and if one of the values is 0 or less then a certain number i want the background color of the ...
Summary: I'm using Excel to link a worksheet to Word, theres no Access involved in this. Sorry to seem a bit dumb about this but how would you use a hyperlink ...
Summary: I'm having an issue where users randomly have issues accessing certain larger customers entered in Act!2000 software. Depending on the amount of attac...
Summary: Hello Everyone, I am new to this forum, so thank you for all of your assistance. Here is what I am tring to do. I have created a worksheet in excel '0...
Summary: I have a main database of information. I download new data off of our website and copy and paste it into my main database. when I do this, it turns ...
Summary: Hi, In a worksheet the cell contains the a text as well as number. i want the text in one cell & Number in one cell. Example: It is given as Month08 o...
Summary: I loose some data when converting from text..even when I change the format.. example size column in excel worksheet is formated as text.. but when con...
Summary: I am a novice Access user. I am unable to get the answer from DLookup that I am expecting. Question: I just need to find out the minimum wage in e...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
