Search results

Hi Guys, I'm using the code below to split data into multiple sheets but instead of splitting it in the same sheet I'd like it to be split in a new workbook. I mean, open a new workbook for each cell value informed. Could anyone help me on this? thank you!!!! Sub Splitdatatosheets()...

Hi guys, I need a macro to check in a specific column if there is at least one single value <> than the one stored on variable Plant, and if it does the macro should not run. I'm trying to use the code below but it does not check first for a <> value but to the same value and because of that...

Hello All, I'm utilizing the code below to send e-mail in Notes via VBA but when the user's signature is on html format I get the error below instead of the person's signature? Can anyone shed any light on that? Thank you! C:notesdatafooter2.htm "" Sub SendEmail()...

Hello All, I'm utilizing the code below to filter a data in a Sheet. It does select the cells I want to filter but the filtered cells are not visible to me. Selection.AutoFilter Field:=2, Criteria1:="#N/D" Can you pls help me to correct the code? Thank you.

Hello All, hope you can help me again on this one :-) I have an spreadsheet with information from two different sources split in two tabs and I want to put all of them in one single tab for me to be able to calculate the lowest price properly. First tab - 'Automatic' - is the format I...

Hello All, I'm trying to create a pivot table to identify the lowest price paid in a product. It works fine until I add the supplier name on the table, then it shows me all the prices and not the lowest one. Please find below the example: http://www.sendspace.com/file/13d6rg Can anyone...

Hello All again, I'm having trouble in trying to write some for next loops. I have an spreadsheet with 9 columns and on the 8th column I have some rows that are with value 0 which I need to remove the entire Row. When I run the Macro below it does not remove all rows and I have to run it...

Hello All, I'm new to VBA and I'm trying to write a code for the spreadsheet below but so far I had no success. http://www.sendspace.com/file/mu39la What I need to do is to multiply all values in each column by the number on column M if the values on range B2, C2 and so on are marked as...