Hello, You can use INDIRECT function, something like INDIRECT(CONCATENATE(A4;"!$A:$A")) instead of KESORAMIND!$A:$A then name of sheet in formula will be used from cell in column A.
Best regards, Martin Gasparovic On Aug 18, 12:36 pm, Subu S <mail_to_s...@yahoo.com> wrote: > Dear Members > > I have a spread sheet with company (listed Indian company) data in individual > sheets and some summary on the top sheet. e.g. Data about quarterly > performance of KESORAM INDUSTRIES is in a sheet called KESORAMIND and the > price of the scrip KESORAMIND, PE ratio etc are worked out on a top sheet / > summary sheet, where a row would contain data on KESORAMIND > > As and when I need to analyse a new company(listed Indian company) , I > (a) open a new sheet on the company name...for e.g. If I need to analyse > VOLTAS I open a sheet tiled VOLTAS > and > (b) add a line on the summary sheet with a row starting VOLTAS > > On the Summary page I copy the formulae from KESORAMIND line, change sheet > references in the formulae to to VOLTAS and paste against the line > VOLTAS > > A sample is enclosed to this mail > > This is getting rather cumbersome as I proceed further... > > Is there a way to include sheet references automatically in a formulae ? or > make the next two of the summary sheet automatically refer to the next sheet > ? .... or in some way simplify the copy + change process ? > > Alternatively : > > If there is an auto updater picking up similar data from NSE / BSE / Yahoo > etc please let me know > > -- > Thanks in advance for your time and patience > & > > Best Regards > Subu > > mail_to_s...@yahoo.com > > Get your preferred Email name! > Now you can @ymail.com and > @rocketmail.com.http://mail.promotions.yahoo.com/newdomains/aa/ > > Quarterly results - sample to group.xls > 52KViewDownload --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 -~----------~----~----~----~------~----~------~--~---
