Recent content by Maria Clara

Luke, thank you so much .. It is just perfect! :DD Quick question: Some of the values on column 11 might sometimes have invalid characters, I've found the code below online but I'm not sure where I should include this on the code you gave me. Can you shed a light on this please? Sub Query()...

Sorry, Luke! Here you go !!! thanks again.

Please find the link for the file! Thanks a lot !!! http://www.sendspace.com/file/u8n1rr

Hi Luke, thanks !! I've just tested the code and it is still splitting the data on same spreadsheet and now the spreadsheet data are being duplicated after I run the code in each new sheet. Would you mind taking another look at the code? thanks again!

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

Will do that, thank you for the tips !!!!!

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

Narayan, thank you for your explanation and help, it has worked perfectly. I'm still trying to get used with For Next Loop since I heard it is good for a lot of things so your explanation was very valuable. Shrivallabha, thank you so much for your help also, always interesting learning new...

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

Narayan, I've just tested as you said and it works PERFECTLY! Thank you SO MUCH for your help! Faseeh, thank you for your help too! Regards!

Great! Thank you soo much! Can you give a tip about the numbers? After I run the macro the numbers are showing as text, is there a formula to change it back to numeric so as I don't have to do it manually? Thank you again! Below is the file updated: http://www.sendspace.com/file/4yrr2o