Recent content by gahill

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...