Thank you so Much Paul and Don for your valuable help.....:-) D On Fri, Oct 14, 2011 at 10:02 PM, dguillett1 <[email protected]> wrote:
> I used some defined names with sumproduct. See attached > > > Don Guillett > SalesAid Software > [email protected] > > *From:* Anupam Konhar <[email protected]> > *Sent:* Thursday, October 13, 2011 10:58 PM > *To:* [email protected] > *Subject:* $$Excel-Macros$$ Expense Sheet -- Need Help Urgently > > Hi All! > > Need your valuable assistance with the attached excel file. > > - The Sheet 1 which has *Exps* has different items, and now in sheet 2 we > have categorised it to mainly 3 items. > > > 2. MATERIALS & EQUIPMENTS : will comprise of Equipments, Eqpt Rental, > Safety & Products, Hardware, copper slag, Eqpt Rental. > 3. CONSUMABLES: will comprise of Diesel & Consumables. > 4. ADMIN CHARGES: Transport, Salary, Levy/CPF, Admin, Food, Entertainment, > Sub-con and Others. > > So need help with this and also want to check if next time when i enter the > expense for the future months, is it possible to automatically capture the > data from sheet 1. > > Thank you for the help in advance. > > Thanks n Regards > > Anup > > > > > > > > > -- > > ---------------------------------------------------------------------------------- > 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 @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > 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 @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
