Clint Have you thought about using formulas for your summary sheet? That way you won't need to copy to a summary sheet, repeat the process, and then delete it the following day. The formula will keep your summary sheet constantly updated. You would need to set it up to begin with, but after that - no maintenance!
For example, first you find out what cell number contains the value you want on your summary sheet. Assuming Sheet1 is called "FirstSheet" and the Value you want displayed on your summary sheet is in Column C Row 84, put the following formula on your summary sheet - in the cell where you want the data from your first sheet to appear =FirstSheet!C84 If your sheet name has a space in it, you will need to enter your formula like this: ='First Sheet'!C84 (with single quotes around the name of the sheet.) HTH Jeanette On Aug 24, 6:45 pm, Clint Stevens <clintontstev...@gmail.com> wrote: > Help: I have 40 spreadsheets in one workbook. I update the > spreadsheets daily. I want the last row (Values) on all 40 > spreadsheets copied to a summary sheet everyday after I update the > data. How do you do this? After the data is summarized and I review it > I will then delete the data in the summary sheet and repeat the > process the following day. > > Thx, Clint -- ---------------------------------------------------------------------------------- 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
