Hi Venkatesh i have uploaded the File jsut now ( 02:00 PM IST) in the Group folder http://groups.google.com/group/excel-macros/web/sample%20sheet.xls
Please let me know the answer On Aug 24, 9:53 am, Suhas <chet...@gmail.com> wrote: > Hi Venkatesh, > > How can i send the attachement, i cant find any options here > > On Aug 18, 4:00 pm, venkatesh <venky...@gmail.com> wrote: > > > > > hi Chetan! > > > Can you please send a attachement with an example, which can help us > > to sort the isssue ASAP. > > > Regards > > > On Aug 18, 2:42 pm,Suhas<chet...@gmail.com> wrote: > > > > Hello Experts, > > > > I have a worksheet where the user enters all the data, and the second > > > worksheet gets updated based on the formulas linked to first sheet. > > > > 2nd sheet depends upon the entries in first sheet with the help of > > > formulas, Now the user should copy the formulas or if the formulas are > > > copied for all the rows the file size increases. > > > > Is there a code wherein the excel copies the last row formula and > > > applies it to the below rows automatically. For example: When the user > > > opens the sheet a macro should copy the last row in second sheet and > > > apply the formulas to first 50 rows. Then user enters 10 line items > > > and second sheet gets automatically updated, While closing the file > > > the additional 40 rows in sheet 2 should get deleted. > > > > Please help! > > > > Regards, > > > Chetan J- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
