Search results

I have attached the files for refernace - I am need of getting the specific row and column from the 4 product files ( the row and column headers has been called out in the Summary file). Hope teh sample file makes it easier for coding purpose. Thanks

Sure will try to make some data sample and post it here

Appreciate if any help can be provided, Thanks

Hi All - I am looking for a macro to extract data from multiple (15+ excel files) data file basis an intersection of row col header which is pre defined in the summary file. In the Data file the row & col headers are same for all (15+) files for a given month, in my summary file criteria keeps...

Thanks, I have been not very active and surely creating confusion for all. Giving it a last shot To put it simply I am trying to get value from 5 different files in a recon file one below the other. The source file is = LOB1/2/3/4/5 - prefer to select the folder and the file names can be...

I don't think I understood your earlier reply, I will ask this question in the right forum (under VBA)and with more details. Thanks

Hi Marc - With the above solution I can only open and copy one file at a time. Instead I need is to work in loop for all the files I have listed.

Hi All, I have to reconcile two sets of files in different folders on a monthly basis, currently I open each file apply filter if required and paste value in the recon file. Takes a long time manually. I have attached a template , where - - Folder path is mentioned in cell C3 & O3 - File...

I have a further question, Is it possible to align the subtotals as left and the rest with one space in the beginning.

I got the solution to that by using Accounting Format.

I see that the underline condition is only to the list of the number in the cell, is there a way to extend it to the complete cell width?

Awesome, Thanks a ton, I will apply to my file.

Hi All, Is it possible to format (Underline rows) previous rows based on cell values in a column using Conditional Formatting. A B C C D 1 Mango 5.7 11.5 10.5 3.4 2 Banana 0.3 0.3 0.3 3.4 3 Apple 0.7 0.7 3.7 3.4 4 Fruits 6.7...

Great , we are on the same page, Thanks. Just so to know is there a better way to write to code other than using 'Worksheet_change'. Regards.

Thanks for the reply, Will go through the link, Just to be clear 'undo' function I am referring to is the excel undo and not the macro to undo the macro. Regards.

Hi All, I need the hide rows macro to run after the selection is made from a drop down list, which will trigger the change in value in column AE, currentl;y I have to run it using Alt +F8. Please advice. Sub HideRows() BeginRow = 1 EndRow = 100 ChkCol = 31 For RowCnt = BeginRow To...

Hi All, I am trying to get a two rows formatted based on the value in the range, my code has a event worksheet_change which is disabling my excel undo function, I am not at all comfortable with this, is there a better code to give me the result - Below is the code I am currently using -...

I am really sorry, if you are aware of forums for Word VBA, Please share. Thanks in advance.

Hi All, I am struggling at this, I have received 200 word documents for which I need to make set changes on all, Below are th changes requested - NOTE : All Word Documents are password protected, and after the changed are made need to be saved as current month - 1 - Logo to be replaced...

Is'nt there a function which I can create to solve this?

I have a pivot and because of the data size its becoming and issue, using Formulas looks like the only option.

Hi There, I am struggling with this, I am looking for a formula to get the Amount based on channels coming from different columns, As in the attached file - I need the sum if formula for getting the amount for each Channel , which is based on the data from Different Columns.

I have now changes the SQL query to have all group by - Is it possible to build the VBA around it the file I attached above.... Regards, Bala SELECT RDW_PROJECTS.PROJECT, RDW_PROJECTS.PROJ_GOC_OFF AS [PROJECT GOC OFFICE], RDW_PROJECTS.PROJECT_NAME, RDW_PROJECTS.ED_NAME...