Hello Gurus, 1. Attached is the sample data what we get from the Server
2. The raw data might not have all the LEVELS, where as our report template
in Sheet2 has all the levels
3. Now, I need to pull the data from Raw Tables to Sheet2
4. Here the range may change whenever we refresh the data for next month
5. Our formula should take the range dynamically
6. I tried using Vlookup and Address functions, but not able to get the
result right
6. And also need to update the formula if the range changes the Year block,
in this 2008 to 2009
Example: For 2008 the range should be :$B$3:$I$11
For 2009 the range should be :$B$12:$I$19
Your help on this is much appreciated
Thanks in advance
Best regards,
Ramesh
Note: Here, every block of the data ends with "Total" row
Formula to retrieve the result dynamically
=ADDRESS(ROW(B$12),COLUMN($B12))&":"&ADDRESS(ROW($I19),COLUMN($I19))
--
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Dynamic Ranges.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
