Search results for query: *

We are running SAP version 640, and Excel 2007. Since upgrading to Excel 2007 when exporting data (not saving to file) the data is in scientific format in excel. Any help would be appreciated JMuscat

I have a large amnount of data exported from a program called pronto. When I import this into SAP from Excel I get an " in front and at the end of the text string. I have tried find/replace to exclude this but still happens. Any ideas

I am wanting to create a macro that will add a zero to the front of certain cell numbers. I cannot seem to work it out. Say column A has 856, I need a macro to change it to 0856, but also use the macro on other values in other cells. Any ideas

I am wanting to create a macro that will add a zero to the front of certain cell numbers. I cannot seem to work it out. Say column A has 856, I need a macro to change it to 0856, but also use the macro on other values in other cells. Any ideas

I want a macro to find a specific word say in column A,then pick up the amount of the next column (b) of the same row and return the amount to another column say H. The problem is that the place where I want the amount to go will always change, but would be at the next available blank row in...

I am recording and writing a macro to format an imported data file into excel for users. What I am having trouble is, I need code to loop down a rows containing data, find the first blank row and then delete the next ten rows. Can someone help me with the code. jmuscat

I have a large spreadsheet of data imported from SAP. I am now attempting to do a vlookup against this data with another spreadsheet. The problem is my customer number column is reading as Text, so that I cannot successly sort in proper ascending order, ergo my vlookup is not working correctly...

I am still a novice with vba, and I have created an excel workbox with macros to automate some functions. Now I would like to add code to the macro, so that when the workbox is opened, it will execute the macro instead of having a macro button on the spreadsheet. Could someone help me with the...

I am still a novice with vba, and I have created an excel workbox with macros to automate some functions. Now I would like to add code tothe macro, so that when the workbox is opened, it will execute the macro instead of having a macro button on the spreadsheet. Could someone help me with the...

I have a user who reads/responds to emails on her managers behalf. I have set up permmissions for this user in the managers mailbox for complete access. When this user opens her managers email and replies to an email, it shows her mail address as the sender, not her managers. What do I need to...

I have auser who reads/responds to emails on her managers behalf. I have set up permmissions for this user the managers mailbox for complete access. When this user opens her managers email and replies to an email, it shows her mail address as the sender not her managers. What do I need to do...

I have a pricing table showing different widths and heights with the pricing in the column header. This was created through a pivot table. Table ref A18:K18 I need to compare width and height from another table D885:e885 with the pricing table and return the correct price in f885 match against...

My company is rolling out Windows and Office XP in the new year. Can anyone point me to material that specify all changes/additions to the software. There are plenty of books/training material around that cover all aspects, but I only want the changes. Many thanks

When I turn on the Word as my Email editor option in Outlook 2000, and then attempt to start a new email, I receive this error message "This form requires Word as your e-mail editor, but Word is either busy or cannot be found. The form will be opened in the Outlook Editor instead". I...

I have a user who created a copy of a worksheet, then deleted the original file. Somehow there are links on the copy file referring to the original file that was deleted. How do I sever these links. I cannot do Paste Special => Values Only as there are formulas on this worksheet.

I need to create a stacked chart as per data below Stack showing profit and sales totalled for 2000 and same again for 2001 for each company on the x axis. Hope this is clear 2000 2000 2001 2001 Sales Profit Sales Profit CoOne 1000 500 1110 510 CoTwo 1100 600 1200 500 CoThree 900 400 800 300

I have a list of names, by firstname thensurname (same column). I want to reverse to show Surname, firstname (same column), by using this formula =RIGHT(B7,(LEN(B7)-(FIND(" ",B7))))&" "&LEFT(B7,(FIND(" ",B7))) but i also want to add to formula to also change...

I have a worksheet where depending on what is in the description column regulates what will be inserted into another column. In the description column there may be several words not included in my formula as well, so I cannot use lookup formula. The first part of of IF statement works, if true...

I want to set up a rule for email messages that acknowledges I do not work on Wednesday. For example a rule that applies to emails received on any Wednesday with a return message to sender stating Wednesday Non Work Day. Is this possible?

One of my users has a problem with his name not appearing in emails that he is sending, the field appears blank. He says that it does not always happen. Is there a way to mask/hide the sender details?