Search results

I have done the changes and it's working. Thanks for your help and time.

Thanks vletm for your prompt response. Just want to extend the condition to another level. Now, is it possible to highlight the date, if it is + one month greater than the current month's date? This means, if today's date is 03-Jan-2023 then the index of the month is 1 for Jan and now I want to...

Hi Experts, I am trying to highlight cells in the A column if the value is date then only it will check for the condition where it will be highlighted if the date is older than the current month and year. I have attached the Macro workbook. Regards, Uday Sub highlightDates() Dim currentMonth...

Hi, I am facing issue to find out exact match. Please help. I have attached the code herewith. strsub is variable and contain the string. and "Cross Charge" is the value which needs to be looked up in strsub string. The issue is if "Cross Charged" is mentioned in a string Macro is also...

Hi, I need a help on below code which will find the match and pasting the data accordingly. Attached is the Excel macro template. Condition for "if statement" if the customer id found in "Detail Sheet" then copy and paste the information finding the empty row below the data set. if not, then...

Thanks for helping

Hi, I have written one vba code where Data 3 will be delimited by "," and inserting rows depends on delimited values count. Now, the this code does not copying respecting data which is present in Data 1 and Data 2 rows. I have paste the expected output in Expected result tab. Please help...

Hi, I want to create a macro where positive and negative line items are matched up to 0 and move to the Clear tab. I have already provided the desired output that I want to generate. For Prosun there are 3 line items with the same value in different integer, however, I want to pick up the first...

Hi, I am trying to split the data into multiple rows in Sheet1. But EXCEL vba is not working in "SPLIT" function. It is stopping there and not going to the next line of code. I have provided desired output data in Output tab. Please see the attached file. Thanks & Regards, Uday

Hi all, I want to calculate the sum value of the Price column in the attached file. However, the challenge is the data range in the Price column is not fixed like if I want to insert a new row the sum range should automatically change based on Item column data. Moreover the 0 and "-" are in...

Please, any response from the forum would be highly admired!!

Hi all, Happy new year!!!!! I have a master data file where data is changing under three categories for every financial period. Now, for each category, I have separate files (Apple, Mango, Lichi) to update them for the current period. As of now, data is updated till period 11, however, I have...

Thanks!!!

Thanks!! Working like a charm. This macro needs one very small change further. This has been realized later. If the cell value is A then the file should be saved as Apple and B as Bat, C as Cat, and D as Dog. Awaiting for your response. Regards, Uday

Hi RDAngelo, Thanks for your help! and Time The Macro is working fine but it is not saving the file into the Downloaded folder with the naming convention mentioned in Cell value A1. Like, if the file's Cell A1 value is "A" then it should save as the file as "A" not 1,2,3....etc. Do let me...

Hi, Hope you guys are doing well!! I need a macro that will open a file from downloaded folder one by one (Loop) and save it based on Cell A1 value. Like, in the downloaded folder if the first file has cell value A then it will save the file as A in the A folder and B in a B folder. Basically...

Thanks for the reply, Sir. However, I want VBA to job done.

Hi all, I am trying to sum all value from A to C category in the Total column by rows. Now, if Column A has value then the only sum function should applied in the Total column. Otherwise, it should remain empty. I have attached the sample file herewith.

I have attached the file can you please apply in attached file?

Hi team, I need total sum of WD1 for BSC ,cleaning and pest in B2,B3,B4 cells. Same way this could also applied for WD2 and WD3 cells. The data tab is Sheet2. File is attached. Regards, Uday

Thank you very much vletm for the suggestion. It is working fine now.

Sorry for not following the code tags. Answer to your question related to "wb" (Reply # 10). I wanted to create a variable where I can represent all input file Book1, Book2, Book3 by "wb". It was not working and was showing subscript out of range. I could not find the reason. I wanted to do...

I have written the code in different way to work. It is working now. But still not satisfy. Want to do it in loop process. Please check the below coding and please ignore my reply at 5.12 pm. Book1, Book2, Book3 should have Mango, Apple, Lichi sheet which will copy to ABC workbook. Can you...

No, it is not working with the second for next loop process. I am getting error in below mentioned line. Sheets("ABC").Copy After:=Workbooks("wb").Sheets(1) Error message - Subscript out of range. ABC is my target file. where I want to copy the ABC sheet from ABC workbook to Book1...

Hi vletm, I have wrote the below code. however not getting error . Please help. Sub test1() Dim path As String, path2 As String, i As Integer Dim wb As String On Error GoTo errh path = Range("E2").Value Workbooks.Open Filename:=path Windows.Application.Workbooks("Macro...