Re: $$Excel-Macros$$ Distribution-Supply Chain/Retail Sector

Hi Ramesh, Attached is the sample file for your reference.. hope it meets ur requirements to the nearest... You simply have to put the total stock in cell A2 and the stock requirements for the respective Branches in the cells B2,C2 and D2.. etc. The values will automatically get updated in the

Re: $$Excel-Macros$$ Distribution-Supply Chain/Retail Sector

Sorry, ignore the previous mail.. pls find the attached one... On Tue, Jan 11, 2011 at 12:20 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hi Ramesh, Attached is the sample file for your reference.. hope it meets ur requirements to the nearest... You simply have to put the

Re: $$Excel-Macros$$ Unique numbers using Macro OR Foumula

Thanks Ashish but blank cell is coming in the middle of the column. On Tue, Jan 11, 2011 at 10:57 AM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Tue, Jan 11, 2011 at 12:19 AM, Sundarvelan N nsund...@gmail.comwrote: Hello Friends, Can anybody help me

$$Excel-Macros$$ How to copy a cell data into Comments

Hi , I have a list of data which I have to copy in the cell as a comment, For exmaple the data in Cell A1 , should reflect cotents of B1 as comments in Cell A1 , I am not aware how to programme it , I have 1000 of lines ,to update , Can you please help me to do the same reduce my effort

$$Excel-Macros$$ Fwd: PAGE PREVIEW -- DIRECT TO PAGE NO.

Hellow Sir, I am using the Excel 2007, Can we have the option of Go to direct required Page No. under Page Preview. For ex. - I have 200 Pages in my work sheet. In Page preview i want to see page no.17 Can it possible the page no. direct option. One way is to go to print option write page no.17

Re: $$Excel-Macros$$ Unique numbers using Macro OR Foumula

I created a macro to load the Unique Numbers, then I created a Change Event to run the macro whenever a change takes place in the target area: - Option Explicit Public Dict_Val Sub Load_Data()     Dim R, C, Rcnt, dKeys,

Re: $$Excel-Macros$$ Understand macro code in timesheet

Yes, you can email it to: schreiner_p...@att.net It SOUNDS like it's an old-style macro. But I'm not sure how it's actually working. I'll take a look at it and see if I can recognize what's happening. Paul From: anil dhi...@gmail.com To: MS EXCEL AND VBA

$$Excel-Macros$$ Formula of the week - share your best formula

Dear Group, Let's discuss excel formula this week. Each of us use many formulas in our excel reports , dashboard metrics etc. Please share your best formula and the reason for being the best. If all of you will share atleast one formula, Then I hope to cover all formulas in excel. :D My one of

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi group, My formulas for the week is 1. normdist = to find the normal distribution of random numbers. 2. FV = To find the future value of the cash flows. 3. stdev = to find the standard deviation of the distribution. Thanks Regards, Kenil Gala From: Ayush

$$Excel-Macros$$ Excel code changes not seen by others

Need some help here, and I thank any response in advance. I have a vb macro embedded with a spreadsheet, and when I send it to others they are not seeing the changes. I simply added a comment line at the first line, save the xla, and save the spreadsheet (just in case) and nothing. I see the

Re: RE: $$Excel-Macros$$ Linking spreadsheets using INDIRECT

hi, use ISERROR for any version On Jan 11, 2011 7:41am, Dave Bonallack davebonall...@hotmail.com wrote: Hi, If you are using xl2007 or more, you can use the IFERROR function. In your case, I think the syntax would go something like this: =IFERROR(INDIRECT(A1D$65)*1,Linked Workbook

$$Excel-Macros$$ Fwd: Excel 2003 vs 2007

Hi Friends, I just wanted to share this differences between Excel 2003 and 2007. Number of Rows and Columns One of the main developments in Excel 2007 is that it allows more columns and rows. For many users this may not be an issue - after all, the 65,536 rows and 256 columns provided by

Re: RE: $$Excel-Macros$$ Linking spreadsheets using INDIRECT

Hi , You can use a UDF in Excel 2003 compatible with the Excel 2007 IFERROR function: *Function IFERROR(ToEvaluate As Variant, Default As Variant) As Variant If IsArray(ToEvaluate) Then IFERROR = IIf(IsError(ToEvaluate(1)), Default, ToEvaluate) Else IFERROR =

$$Excel-Macros$$ Re: Fwd: Excel 2003 vs 2007

Thanks Raj for sharing knowledge with Group Members. I appreciate it. Best Regards, Ayush Jain Group Manager Microsoft MVP. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

$$Excel-Macros$$ Business Object interface with Excel

Hi guys, sterday i joined new comp n it was my 1st day. i came to know i m gonna work on business object. i dot know it. can anybody tell me how can i get info abut it. also, i was told i might need to interface this with Excel. Any idea if we can do that? n if yes then how? Thanks, Hanumant

$$Excel-Macros$$ Words after the excel data - Urgent

Hi I am using Excel 2003 i want to use a big set of words after i print my excel sheet say 2 pages of words, but i need to print it, exactly after my excel data is over , say some times my data comes to 2 pages some times it comes to 2 and a half pages what ever it is after the excel data is

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi Group, My Best Formula for this week is. SUMPRODUCT()-We can use it instead of *Sumif*,*Countif*,*Sumifs* and *Countifs *in 2003 or 2007. -- Thanks regards, Noorain Ansari On Tue, Jan 11, 2011 at 9:09 AM, Kenil Gala keni...@yahoo.com wrote: Hi group, My formulas for the week is 1.

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi Group My Best formula for the week is: XNPV() - We can use it to calculate the net present value of a cash flow. Thanks Regards Sumit Kumar On Wed, Jan 12, 2011 at 11:36 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Group, My Best Formula for this week is. SUMPRODUCT()-We