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...
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...
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 -...
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...
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 love this, this is my 3rd thread in 24hrs....
I have a template which I have attached, this has macros to pull data from a particular query and makes a file for each country based on the Base file,
thanks to the members here I was able to reach till here
now in addition to what i already...
Hi, I have a period column which has 12 months rolling period in yyyymm format (201210 - 201309), I need two columns YTD and MTD, based on what is there on the period column teh YTD and MTD should auto calculate , Don't want to use any reference cell apart from what is there in the period...
Guys need help, not sure if this is enough or you need more details -
Public oApp As Object
Public strDB As String
Public Wbk_Base As Workbook
Public strPDF As String
Public Sub Initialize()
Application.DisplayAlerts = False
strDB = Worksheets("Input").Range("B2")
'strPDF =...
Hi,
I have recorded a macro to save the data source in the background of three pivot tables, The macro is too specific to the three pivot I have, is there a way that it works on any pivot
Sub Pivot()
'
' Pivot Macro
' save data source
'
' Keyboard Shortcut: Ctrl+e
'...
Hi Guys, Not sure if this is the right forum, Do let me know will re post.
I am looking for a Sample WIP Expense file, showing Expenses by current month actuals , CY YTD Actuals , MTD Actuals VS MTD last year, and CY YTD vs LY YTD.
Rgeards,
Bala
Hi,
Below is the Macro I run - To create a copy of the base file and to get the required data and deleting the rest, and refreshing the pivots, this work really great, thaks to debraj (excel Ninja).
Coming to the point - the new file created has three pivots , and the range it has is of the...
Below are the two Macros I am trying to save on Personal.XLSB, its runs fine, once I close the excel application, and reopen, the macro is gone.....Am I doing something wrong, this is the first time I am working on Personal.xlsb.....
1) The code below is to get the number in the selected cell...
Hi Guys,
Here is a macro to for getting to the classic view on pivot via a shortcut(Ctrl+r). however the macro has made the pivot very specific to Pivot table 8 , I want it to work for any pivot.
Sub Classic_Pivot()
'
' Classic_Pivot Macro
' to convert to classic view
'
' Keyboard Shortcut...
Hi, Need urgent help is this, have to submit the file by monday -
this is how I have the file
- On the 'Main' tab there to list criteria's which need to be selected, once selected the formula in the rest of the tabs (Actuals, Budget,Headcount,LY Actuals) marks the relevant rows.
Now I need a...