Use the function LOOKUP(9^9,A:A) 9^9 = 387420489 Because this value is not in your range A:A, Excel return the last value of your range.
Then, you copy/paste this formula 40 times and you just have to change the column's reference. And if the hearder of your report worksheet is equal to the worksheet's name, you can use the indirect function On 24 août, 19:45, 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
