Search results

This is what I use for another query, where the data is pulled in in excel, though the query does not have any parameters in excel, its all in the query..... Trying to use this .......please let me know your views.... Sub Get_data() Dim db_path As String Dim oAccess As Object Dim rst As...

If any help here is the SQL for the new access query SELECT RDW_PROJECTS.PROJECT, RDW_PROJECTS.PROJ_GOC_OFF AS [PROJECT GOC OFFICE], RDW_PROJECTS.PROJECT_NAME, RDW_PROJECTS.ED_NAME, RDW_PROJECTS.SOFT_OPEN_DATE, RDW_PROJECTS.SOFT_CLOSE_DATE, RDW_LOCATION_HIERARCHY.L6_PARENT_NAME FROM...

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 guys, sorry for the delayed reply, and Xiq sorry for the "MTD" and "YTD" terms, think I was able to solve it , I was looking for getting the MTD and YTD text if it was current month and Current year respectively. I changed it in access and have put in formulas MTD: IIf([PERIOD]=[Enter End...

My fault with the title, your formula gives me the previous month, but i need it to calculate if its MTD or YTD, based on the max month in the period column....

Thats okay , will be good to see that its been solved....... Thanks Luke.

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

By the way ...how do I mark it solved.....????

Hey Guys, this was no test, you pple are just amazing, you know how it is when you are about to present a report and the file doesn't run.....well had that experience yesterday.....thanks to you guys......or else the joke would have been on me..... However I have more come on this will start a...

:(....Any solutions that i can try here.....

Its gives me a error as - "Compile Error Next Without for" quick help needed.... Thanks & regards

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

Great, this is very helpful. Thanks Bala

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 Sam/Narayan, Thanks for all your effort and time, this is working great, and the pivots are now using the excat range. Thanks again. Regards, Balaji

Hey Narayan, I am still not sure where to copy it...sorry for the trouble.....

Hi Narayan, It give me a Compile error as : Sub or function not defined Highlighting 'R1C1converter' from the code. Regards, Bala

Hey Faseeh, Thanks for the file, is there any way to populate the expense categories depending on the what is there in the data, And also hide the row if the value totals up to zero in the row.

Hi Narayan, I tried using Sam code to solve the issue, however its not working and gives me a error, I have to manually change the Pivot range to the pivot file. Regards, Balaji

You can try that.....

Hi Narayan, If you see the pivot table its linking to the the base file and not to the file the pivot is in....hence Sam gave the code (before and after), but if you insert Sam's macro in my file its giving an error...... Regards, Bala

Hi Sam, below is the link - https://docs.google.com/file/d/0B00CYZ_WSBc6aXVFczdIakV4WHc/edit?usp=sharing Thanks, Bala

Hi Faseeh, Thanks for the reply - Attached is a sample file. In the Sheet 1 tab - Is what I need to have automated - - the catch under the PL_category the expenses heads keep increasing ... - I need it to include all the unique expense heads available from the data tab - 'col. D'. -...

Hi Sam, Sorry for the delayed one from my end, and Thanks for the reply. I got the file from my partner for tis month, and tried with your code but again gives me a debug error. Please help ub GetData() With Sheets(1) ParentDept = Left(.[G3], 4): dept = Left(.[G5], 4) '...

Hi, Did check it out...but nothing which suits my requirement, Let em know if anybody has a file to share. Rgerads, Bala