Search results

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

The Issue here is - The pivot is the new file carriers the range from the base file. Sub GetData() With Sheets(1) ParentDept = Left(.[G3], 4): dept = Left(.[G5], 4) ' fname = "\" & .[c3] & " - " & .[c5] & " - " & _ ' MonthName(Format(Date, "m") - 1, True) End...

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 Luke, The macros work fine but started facing a funny issue, i save the macro on Personnel XLSB,and I have also linked it to a icon in my customised ribbons, but when I close excel fully and open it again, there are no macros in Personnel.xlsb, and neither do the icons work. Am I missing...

Great.Thanks, This is so far the best forum i have been. Regards, Bala

works like a charm, thanks I am looking for a pack of simple macros to save on my excel personnel workbook, is there any source I can get it. Will make my like easier. Regards, Bala

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 Deb, Did you get my Mail???

Hi, Any feedback or solution....???

Hi Deb, I am banking you a lot, https://www.dropbox.com/s/s2fvrnvj17c4epx/Sample%20Format%20File%20%28No%20data%29.zip Above is the link to my file , I have deleted all the data, hope that is fine with you, So that you get an idea of the format and the tab manes, as I was not able to use...

Hi Deb, The macro works fins on the sample file but not on my file , the auto filter need to be applied on Col Z i.e. 26, the col which needs to be filtered in 4 tabs does not a fall in the same number. Hope you get it.

Hey Deb, I need the 'Main' Tab as well in all the files, will that be easy??? Regards

Hey Deb, Saw the post right now, thanks for the file works like magic.....will try that on my file. Will update you on that. Thanks a ton Regards, Bala

Hey Deb , Aplogies on the Tags, also good to know how to share files, Below is the link to the file on Dropbox https://www.dropbox.com/s/w7zaz1a934z4584/sample%20file.zip If this is replied asap, I can start working on 75 files Which I have to produce. Rgeards, Bala

Hey Guys, I'm Balaji from Chennai, India. I work for a Consultancy Firm, Excel has not been new to me however the I am new to VBA, I always wanted to make this easier and simpler using excel. Hope I hear quickly on the latest issue I have posted. Thanks, Bala

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