$$Excel-Macros$$ control the macro commands in excel vba

2016-02-25 Thread Kat
Hi guys, I have 7 subs in my module. I would like to control that if the datelastmodified of excel vba is same as datelastmodified of the master file, then don't run the 7 subs. If the datelastmodified of both are not same, then run all the subs. What should I put in 'ThisWorkbook' and how do

$$Excel-Macros$$ Fwd: Us congress hearing of maan alsaan Money laundry قضية الكونغجرس لغسيل الأموال للمليادير معن الصانع

2016-02-25 Thread vero A
US Congressional Hearing of Saudi billionaire" maan Al Sanea " and Money Laundering with bank of America With Arabic Subtitles http://www.youtube.com/watch?v=mIBNnQvhU8s *موقع اليوتيوب الذي عرض فيديوهات جلسة استماع الكونجرس الأمريكي * * لمتابعة نشاطات غسل الأموال ونشاطات* *ا

Re: $$Excel-Macros$$ Search and Data Formating help....

2016-02-25 Thread Paul Schreiner
Is it possible to send me the excel file itself?you can send it directly to my email (schreiner_p...@att.net) rather than posting it to the group. Your first question is a bit confusing.Copying values from one cell to another is as simple as: Range("I7").Value = Range("D8").Value Range("J7").Valu

Re: $$Excel-Macros$$ Search and Data Formating help....

2016-02-25 Thread Maju
Thanks Paul!!! it works perfectly fine. This is the code that I have so far. first time working with a pivot table macro. the final result should like the screen shot below. the problem is 1) how do I copy the data highlighted in blue and yellow to the right table in green? I tried using the

Re: $$Excel-Macros$$ Re: How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?

2016-02-25 Thread Paul Schreiner
the "OR" question:you're actually most of the way there with your logic, just stating the question! In an IF() statement, the first part is the "logical test", followed by what happens if the test is "true" and what happens if the test is "false". The "logical test" can be anything that results i

Re: $$Excel-Macros$$ Search and Data Formating help....

2016-02-25 Thread Paul Schreiner
Yes, this is much easier to understand.Did I miss where you mentioned your VBA code before?I TOTALLY didn't understand that you were working with VBA.I thought you were using Excel functions. So, now that we're on the same page, let's take a look at your code: When the macro first runs, colLast i

$$Excel-Macros$$ Intro - Varinder Singh

2016-02-25 Thread Varinder Singh
Hi All, My Name Varinder Singh , i'm also a fan of excel like all of you. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accur

$$Excel-Macros$$ Pivot Table - Copy Row

2016-02-25 Thread TheExpat Wanderer
Please help me on this For the PT attached every time I filter by Cell Zone , there are two rows of interest Total Count & Total Amount when I filter say for Zone A I want to copy the two rows to new sheet . then I filter for zone B , I want to copy the new resulting rows to the new sheet bel