$$Excel-Macros$$ Re: Problem

Hello everybody, I need your help to write a formula. In the attached sheet, you may see that there are three blocks, where zero occurs. My question is how do i formularize it to tell me the same? Thanks a ton! Best Abeer -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Re: Populating rows using a range of data

Hi Mandeep, Many thanks. It serves the purpose but is there any way we can use index/match or any range formula to achieve the same? BR Aby On Wed, Apr 15, 2015 at 1:12 PM, Mandeep Baluja wrote: > check this out. the value which is blank does not go into the bucket you > have set. > > Regards,

$$Excel-Macros$$ Re: Populating rows using a range of data

Dear Experts, I have been trying to figure out a way to populate the row D9 to AM9 based on the table provided D14 to J18. I have tried index/match but to no avail. Any help in appreciated. Best Regards Aby -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

Hi Kannan Interesting query. Would you share why you want an expiry on the file. Just trying to understand the circumstances under which one might want to add the funcitonality Cheers Umar On Mon, Jul 29, 2013 at 12:37 PM, Kannan Excel wrote: > how to make this??? > > can u send code??? > > an

$$Excel-Macros$$ Excel Query - Help Appreicated

Dear Experts I have attached an excel file peratining to payroll situation. I need to identify in one line when a new headcount is added and when a vacancy is created preferably through a formula. Your help is much appreciated. Thanks Umar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Formula Quiz

Excellent improvisation Excel Beginner. Love it! On Sun, Nov 25, 2012 at 10:53 AM, >>Excel Beginner<< < excelbegin...@gmail.com> wrote: > Hi Rajan sir, > > Please find the attachment. I had been given to another > solution. > > > > > > *Regards,* > * > * > *Excel Beginner* > * >

Re: $$Excel-Macros$$ Re:Data Validation

is the issue??* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Umar Abeer > *Sent:* 23 October 2012 1:54 >

$$Excel-Macros$$ Re:Data Validation

Hi Guys I have a workbook with lots of sheets culminating in a P&L. I wish to put a sort of validation that if my final net profit number changes because of any reason, excel throws a validation error? Many Thanks Dino -- Join official facebook page of this forum @ https://www.facebook.com/dis

Re: $$Excel-Macros$$ Animated Chart

I think you forgot to assign macro to the button. On Tue, Nov 1, 2011 at 11:38 AM, NOORAIN ANSARI wrote: > Dear Group, > > Pls find attached Animated Chart. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorai

Re: $$Excel-Macros$$ Power point Query

Hi Alisha, Good work. Can you tell what how did you do it? Regards, Umar On Sat, Sep 17, 2011 at 9:04 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Dear Shrini, > > I am sending you one attachment. Check out if it works. > > > Regards, > Alisha > > > On Thu, Sep 15, 2011 at 5:43 P

Re: $$Excel-Macros$$ Insert multiple rows using macros

; > *ActiveCell.Value = "Product breakdown"* > > *Next* > > *End Sub* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Umar Abeer > *Sent:* Tuesday, August 23, 2011 11:35 AM > *To:* excel-macros@g

$$Excel-Macros$$ Insert multiple rows using macros

, so I need it to loop through all sheets. Thanks in advance. Regards, Umar Abeer -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. J

$$Excel-Macros$$ Locking precedent cell!

Hello Everybody, I am working on a large budget file with numerous sheets, which link up to a master P&L. The problem I am facing is that any small change (unintentional) in any of the sheets render the P&L open to change. This is potentially catastrophic especially with the deadline on hand. Is

$$Excel-Macros$$ Re: Automation of copy paste exercise

Dear All, I am presently updating a month P&L column using links to a trial balance every month. So for the month of Jan, I will paste the trial balance and Jan P&L will populate itself. For the month of Feb, I will copy the links in the Jan column in the next column and will change Jan column to

Re: $$Excel-Macros$$ Re: headcout dashboard report

Hi, You need to email your post along with the attached file to excel-mac...@googlegroups.com. Kindly send me the dashboards as well. Regards, Abeer On Wed, Dec 1, 2010 at 10:56 AM, anandydr wrote: > Hi, > > Sent the dashboard to all those who need it. I have collected these > from internet a

$$Excel-Macros$$ Comparing two trial balances

Hi guys, I have to compare two trial balances every month. Presently, I compare them using a vlook up formula and the account codes against which there is a NA error I add them to the old trial balance. I need a VBA code to automate the identification of the new codes and addition to the rows in