Search results

hi NARAYANK991, Thanks for the above responce, since we pull a report which has more line items, I think conditional formating will not work :(

Dear Ninjas, I have 3 sets namely "Set A" and "Set B" and "Set C" with below values, Set A: A1, AA2, AX3, A4 Set B: B1, BB3,BA2, BB6 Set C: C1, CZ5, CC3, CB10. In a column say "A" when I pull the report, I might get only respected set values or mix of set values of Set A Set B and...

Hi SirJB7 Thank you for reinforcing, I Apologies for the cross post.

Hello, Can someone help how can I copy paste entire piviot table into an email body usig VBA. few sentances on in the begining of the email body and I need to paste the table right below the text. Thank you.

Thanks Dear Kaushik03

Hello Guys, I am able to update the date from the below code, but unable to copy paste the piviot table to a specific part of in the email body and not sure how to update date in the email body. Your help is very much appreciated. Sub sendMail() Dim myOutlook As Object Dim myMailItem As...

@ Luke Thanks VBA Ninja. Its meeting the requirment.

Thanks kaushik03 and Luke, @ Kaushik03, the above code is not working for the desired column values "T" instead its coloring all the values from column "A". As per VBA yes or No command of message box the cell values are required to get the color code. @ Luke, since I am not using a master...

Hello, In column "T" I have more than 1000 line items, If I select yes from VBA messagebox it should color code all the "<0" (negative) values. If I select No it should color code both the "<0" (negative) and ">0" (possitive ) Values. Your help is very much appreciate Thank you

Thanks mercatog for your quick support. Much appreciated.

hi Mercatog, Yes I have mutilple rows having 7s and 6v. The Above coding is woking only for the first instance search of 6v and 7s. Its fine to mention the message as "Premium Products! 7s/6v are hilighted in Red" Thank you,

hi Guys, In the below code I am trying to find the key words "7s" and "6V" from the worksheet "Products". I am able to find and color code only one line Item. I struck to loop it untill it finds all the occurance. Can someone help me pleae? ***********************************************...

sorry again same post repeated twice, lets continue the discussion with this post. Thank you.

hi Guys, I am struck with the below VBA task, > I have an email template stored in desktop in the folder "Templates" and few excell files in folder "files" (which lready has a piviot table) From the master file if I click the respective command button,the template should open, Update...

@ Debraj Roy Excellent, The updated work sheet is meeting my requirment. @SirJB7 Thanks for the formulas to simplyfy my manual task.

Thank you. I am really soory, the above formula is woking when the values are only in HH:MM AM/PM format, but its not working for my data which is in the formate 8/15/2012 12:01:00 PM I have uploded the sample file in the below link...

Thanks Luke, but I am not too sure how to modify the formula in context to =TODAY()+13/24+30/1440 I have uploded the sample file @ Sky Drive. You responce is much appreciated. thank you.

hello, In a column I have values of email received date and time (8/15/2012 11:59:00 AM). I have formulated the work sheet to get the number of emails received in which hour ( using vlookup and hour formulas). For example 10 if mail received between 1 to 2 PM and 85 emails between 2 to 3 PM...

hello, In a column I have values of email received date and time (8/15/2012 11:59:00 AM). I have formulated the work sheet to get the number of emails received in which hour ( using vlookup and hour formulas). For example 10 if mail received between 1 to 2 PM and 85 emails between 2 to 3...

thanks Mercatog, Sorry I dint notice,

Hi Guys, I have encountered once more challenge, for except red for most of the colors I am not getting the exact shade, for example if my sheet 2 line item has green, the result in sheet 1 line item is differing in shade. How can I get the exact ?? Thanks you

@ Debraj Roy Thanks lot cell1.EntireRow.Interior.ColorIndex = cell2.DisplayFormat.Interior.ColorIndex is exactly meeting my requirments. @mercatog Thaks lot for the responce.

Hi Deebraj and mercatog, Thanks for the coding. but it is resulting in defined color. The requirment is if a row in sheet 2 has red color the duplicate row in sheet 1 should apear in red. Similarly this report has different row had different color in sheet 2. The exact color should reflect in...

I have to work sheets Sheet1 and Sheet2 with set of data. I hva to idnetify duplicate values from sheet2 IDs to sheet 1 Id and color code the same formate like what the sheet 2 deal ID has. I am done till idnetification of duplicates but struck in fromating the color code of sheet 2 line item to...