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

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

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 rockerna...@gmail.com wrote: check this out. the value which is blank does not go into the bucket you

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 kannan.ex...@gmail.comwrote: how to make this??? can u

$$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?

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* * * On Sat, Nov 24,

$$Excel-Macros$$ Re:Data Validation

Hi Guys I have a workbook with lots of sheets culminating in a PL. 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 @

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

: *So what 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 *To:* excel-macros@googlegroups.com *Subject:* $$Excel

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 noorain.ans...@gmail.comwrote: Dear Group, Pls find attached Animated Chart. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/

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 PM,

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

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. Join our LinkedIN group

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

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@googlegroups.com *Subject:* $$Excel-Macros$$ Insert multiple rows using macros ** ** Hi everybody

$$Excel-Macros$$ Locking precedent cell!

Hello Everybody, I am working on a large budget file with numerous sheets, which link up to a master PL. The problem I am facing is that any small change (unintentional) in any of the sheets render the PL 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 PL column using links to a trial balance every month. So for the month of Jan, I will paste the trial balance and Jan PL 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 anand...@gmail.com wrote: Hi, Sent the dashboard to all those who need it. I have collected these

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