Search results

Greetings, I think I understand your problem,Below I am going to present a sample code which will help your cause.You have to place the code in the worksheet, not in the module(shown in the image below). First, right click on the sheet1 name in the workbook as shown in the image. And then click...

Greetings mFaisal, Thanks a lot for the follow up. I actuall given my solution based on your previous comment. Which will extract the information from the source files based on the date in the target sheeet. Now what i understood that you want range of data or all of the data available in the...

Greetings mfaisal, I think I understood your problem, and i thereby give you the solution file given below. This file will will check the last date in the A column and search for the data according to this date in other files that you have given and fill them accordingly. However there something...

Greetings ranjit, Thanks a lot for your query. For this problem, you can use the conditional formatting to resolve this issue. In this problem, you asked to check whether a date is greated than 12 months or not. But it is not clear whether you asked for checking whether the date is greater than...

Greetings Frank, Thanks a lot for posting your queries again. Actually, the file serial actually depends upon the serial in which they are now sorted in your pc. If you want a different order, then the files need to sort on your pc according to your preferred order. If that does not solve your...

thanks a lot Frank for your response. First of all, there might be some confusion regarding to your question. That if you want to transpose data stored in the range of cell F16:F20, then the transposed data mustnot be in the same column. But the example output range you have shown, A1:A5, is...

Greeting Rachel, Here I am going to present a VBA code using which you can extract the row values from the dataset as individual txt files. and the column header are going to be included inside each of the text. It always better to provide your original dataset where you are facing issues, with...