Urgent - FINDING Last Row OF data in excel in multiple sheet tabs and creating a new summary tab with last row of data
I have spreadsheet with 2 tabs as my example and I want to pull the total - last row of data from each of the tabs and put them in a new summary work book. I HAVE about 18 workbooks with the same data but some have 3 tabs instead of 2. I HAVE NEVER used VBA before and probably need as much information as I can get. Do you recommend any books I could use to start teaching myself, the file are below.
THANK YOU!!!!!
| Attachment | Size |
|---|---|
| test_attr_jey_march11(1).xls | 35 KB |
Solved
Hi,
For the solution to your problem please check the blog posted on http://excelexperts.com/node/1167.