Search results for query: *

xlbo: Thanks for your reply but a pivot table will not work here. There are approximately 45 categorys and each one needs to be on its on worksheet along with the corresponding items. Thanks

My data is arranged in the following columns. Rows over 2000 but less than 3000 Sorted by Item number within Category. A B C D E Catg ItemNbr Desc U/M Price 20ws 11111 AAAA BX 5.00 20ws 22222 BBBB BX 5.50 20yl 11111 AAAA BNDL 7.00 20yl 22222 BBBB BNDL 7.50...

Tony: I don't understand your response. You create a distribution list in outlook. I stated in my post the distribution name is MARKETING. Manually, if you want to send mail to only the marketing group it shows up in your contact list and you click MARKETING. Then the E-mail goes to only that...

Hello: The code below works and will send my document to all contacts in the contacts folder. What I'm really trying to do is send the document to only those people in my distribution list. The distribution list is called marketing. Public Sub SendDocToEmailList() Dim olapp Dim mynamespace...

Hello LUV, No I have not found a solution, nor has anyone else been able to shed any light here. Sorry. Gary W. Hill

Hi Skip: Problem solved. I had a temporary memory lapse that you solved when you pointed out a string was being returned. I fixed the function and it works fine now. Thank you for your prompt response it was greatly appreciated. Sometimes during a hectic day you cannot see the forest for the...

Hi Skip: My terminology was wrong in my post. The date I'm attempting to display in Excel is what a user is used to seeing 08/09/2005. The people getting the result spreadsheet are not going to use the date for any type of calculations. I just want the result for display purposes. I am making...

Hello: I have attempted to write a function in Excel 2000 to convert a date coming from a legacy system in YYYYMMDD format to a valid date using the mid function with no success. Of course I can do this in a cell and copy the formula to the end of the region and then convert formula's to values...

Hello Zathras: Thank you, that is exactly what I needed and you are correct about the column. Gary

Hello: Column A of my spreadsheet has the beginning of the month date. The work week is from Monday through Saturday. I would like to have a formula take the beginning of the month date and increment column B with the next days date skipping all Sundays in the month. Holidays are not important...

Hello: I have a spreadsheet that subtotals by customer and also breaks page by customer. Does anyone know how to reset the page number to one on group break, or is there a way to place your own page number in the header and how do you do this. Thanks Gary W. Hill

Hello: I have my headings such as date, page number etc in the header section. My data is sorted by customer number. I have the subtotals set to page break between groups. I need to reset the page number to 1 when the group breaks. Thanks Gary W. Hill

Hello Everyone: Thanks for your response. I solved the problem this way. Column A 1 12 1234 12345 Formula in Column B =Rept("0",10-len(A2))&A2 The field being exported back to the Accounting system is 10 long without decimals, so this does the trick. Thanks again everyone for their quick...

Hello: I'm importing a file into Excel 2000. Column A comes in as a text field with numbers. I need a formula to right justify the number in column B and add leading Zero's. This must remain a text field for further exporting to another application.

Hello: Windows 2000 Explorer is configured as follows: Excel comma seperated values file Open Print Confirm Open After Download Checked. WindowsXP is configured identically. When downloading a file from the Bank in 2000 the dialog box would appear asking for the file name to save as. This is...

Michael: Thank you and Chaz both for the excellant help. Problem resolved. Gary W. Hill

Chaz: Access does not like the round function for some reason. Going through help in the VBA and Access provides nothing. Round doesn't even show up under their mathematical function list. Now if I try running your function I always get a compile error. I've tried everything I can think of with...

Hi Chaz: I solved the problem of the report asking for a parameter. I started a new module and just copied the code from this thread. Don't ask me why it works because they both look the same. There is another problem that popped up though. The field is defined as Currency with 2 decimals. The...

Hi Chaz: Thank you for your quick post. I do have a problem though. Unbound Text Box with this formula in the control source =CheckDigit(Sum([TAXAMT])-[Discount]) Function as you sent to me. Function CheckDigit(X As String) As Integer Dim I As Integer Dim J As String Dim RTV As Integer RTV...

Hello: My report is a Sales Tax report for the state. Below are the fields. Gross Sales Expempt Sales Net Taxable Sales Reportable Sales Tax Tax Liability Discount Net Amount Due The Net Amount due is Calculated =sum([Taxamt])-[Discount] For this week that amount is 5277.34 The State wants you...