Hi all. I'm back again. Just in case I didn't outline problem I have clearly enough..........I have sheet on workbook with say 300 weblinks. Is there some way that I can loop through all of these links (each link is to an online excel database with data for each day), copy excel data from website (copy all), and then paste this data into another temporary raw data sheet. Analysis is then done on this raw data and findings need to be then output from analysis sheet to a summary sheet. This is then repeated 300 times, each time overwriting old data in raw data sheet, performing analysis and outputting to summary sheet.
Having something set up like this will proove extremely useful as I intend on running the analysis and reviewing the findings for 300 days. Then once I have reviewed I need to tweak the analysis inputs, re-run 300 times and compare summary findings. Any help with this would be greatly appreciated. Many thanks! On Dec 1, 12:20 pm, skip <weld...@gmail.com> wrote: > Hi > > I have limited understanding on using Macros. I have a workbook set up > with 4 sheets: > > Sheet 1 - contains approx 300 hyperlinks to excel spreadsheets online, > which I want to goto, copy all and paste to > > Sheet 2 - which simply contains raw data from 1 > > Sheet 3 - the analysis on raw data from 2 is carried out here. The > findings are output to > > Sheet 4 - which contains a summary table listing date, and results > from Sheet 3 > > I can run through sheets 1-3 fairly quickly, and then manually output > the findings of sheet 3 into sheet 4. I was hoping to to take the pain > out repeating the task 300 times. I need to run the analysis approx 15 > times, each time adjusting variables in Sheet 3, before running a > macro which will give me a summary of all 300 outputs in Sheet 4. > > Any guidance on how to get this up and running would be very much > appreciated!! > > Skip -- ---------------------------------------------------------------------------------- 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 6,500 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
