Search results

I will keep this in mind for future.....apologise if i have done anything wrong Now can i have solution the problem in hand..thank you

Please check befor commeting...First code i have used is different...i have already posted on another site then i came up with another code so thought before posting this new one...let wait for the solution of older one... Secnond i have not received any solution on earlier one hence no point...

Untill now I have something…now email ids in To and CC mentioned in macro itself and same goes for subject line and body.It should take it from the Cell D2 onwards And it also pasting table from tab 2 according to the range mentioned in it. Problem is if we add or delete any row it will not...

Hi, I am looking for vba code, which automatically send mails from excel. I am working on different vendors and right now I am sending it manually , which took lot of time. Requirement is – I have attached a excel sheet with 2 tabs. Sheet 1 – has all requirements we need to send a mail.when I...

what i mean is...userform can look like this ...Doc file attached

Hi, I need a code for user form , where if we select something in userform it automatically select same thing in pivot. Let’s say if I select ADM in Business Group, GSC in Customer, Site office mgmt. in Process, Adm (Site) and Site (BLR) in user form, it should select same thing in pivot...

i dont have power query...by the way i am ablt to do it via creating pivot and then use slicer to update my table .....many thanks

Hi GraH, This is good but have some shortcoming like we need to find Manager name to type in D3 (I know in my sheet we have same manager name in all functions, like in Mkt we have John only ) But in real scenario we have multiple manager in single function. So need something , where when we...

Hi All, I am looking for a solution where , person id should reflect as per name of manager. We have a data as per site,function,manager name,person ids and month So if we select month ,site,function and manger in that particular function, we should get all person ids reflecting under that...

No problem .....luckily we have more than one champ here....anyways thanks for taking time out for this

Sorry for the confusion Bosco.....your solution in post 10 is working fine..... Thank you for your time....

Thanks bosco and vletm.....it is working....appreciate it.. :-)

That’s not right Alansidman…..as my file clearly show that we have 5 days in oct , 30 in nov,31 in dec,31 in jan and 26 in feb Total is 123…

It is good and thanks for taking time for this @AliGW…but some cells it is not working fine like Cell 3….where our beginning date is 10-09-2018 and end date is 23-09-2018…. Hence my result should be 13 but it is coming as 22.. Same as for cell 2...it is coming as 4, where it should be 1 Please...

Sorry for the confusion....As i mentioned in my first post....simple subtraction from begining date to end date will give me combine figure...that is not wanted...i have done manual calculation in A5 cell...where we can see start date is 26-10-2018 and end date is 26-2-2019....hence starting...

Not working.....i have tried on Cell A5 n B5 and as per your formula number is 118 which is wrong as in simple terms it should be 123....attching revised sheet

Hi, I am looking for a solution, where days should be calculated from begining date to end date and another thing....days for that particular month should be under that month...for example if my begining date is 26-05-2018 (dd-mm-yyyy) and my end date is 31-03-2019..then it should show number of...

Hi After tried and testing several times, it is now giving something else error “Multiple step operation generated errors. Check each status value.” This error is in Record set code and on “rs.Fields(col - 1) = data(index, col)” What would be the reason for it?

Code given in above link is working file to file attached there...but when i try to run on my sample sheet it gives error "User defined type not defined"...can you plz look into this.....thanks

yes when i click on From table/range...it opened query editor....it seems just like a power BI....

Yes i have Get & Transform Data in Data tab....attached doc for your reference..

And why i need is because my first sheet rows are filled up till 1048576 and my data is till jan to july and for Aug month data i need another sheet and now i want want to create pivot from these 2 sheets...

Hi Chihiro....i dont have powe query installed in my machine...what can i see is powerpivot,powermap and powerview..... I tired to run a macro for the same link, which you have provided above but it is only creating a another sheet without making any pivot from 2 sheets.... Topaazy....is the...

Hi, Version is 2013

Hi, i am looking for a solution , where i have 2 sheets of data and i want to create single pivot table...2 sheets data is same except month....first sheet is till jan to oct and 2nd sheet is for nov i know there is option to consolidate sheets in pivot table and i am able to create it but i...