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