Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here goes! Hope this makes since and I'll try to be as basic as possible.
Excel 2003 I have a Workbook with the following worksheets: Form-Print Work-Sheet January February March (Etc. a sheet for each month) 1-The 'Work-Sheet' tab has user data that is input monthly for the prior month and several calculated columns based on that input. 2-All the 'Month' tabs (12 in all) have formulas to extract the data for only that month from the 'Work-Sheet' tab, put it into columns based on the month and year, and has a graph of this data for all the years. All this is done automatically in that 'Months' tab with no user input within that tab. 3-The 'Form-Print' tab is strictly an easy to read document based on a given "month-year" field that is input by the user. This is given to top management at the end of each month showing that particular months info as well as its history from prior years including the graph for that month. I have gotten all the info in the text portion of the 'Form-Print' tab for the month with no problems. All this info comes from only the 'Work-Sheet' tab. My problem is the fact that I need to also get the graph from the correct 'Month' tab for the data as well as automatically size it ti a specific size. I have found nothing to allow me to get the graph from the matching 'Month' tab based on the "month-year" input by the user on the 'Fornm-Print' tab. I prefer to get this done strictly with formulas and/or copy functions. I have no experience with VB what-so-ever and would have to be baby-stepped through it for VB to work. If you have an easy way for me to get this done I'd be forever greatful! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I copy a graph and use the data in the new worksheet? | Charts and Charting in Excel | |||
filtering out records from one worksheet by comparing a field in it with a field in another worksheet | New Users to Excel | |||
Copy Row to worksheet based on criteria | Excel Discussion (Misc queries) | |||
copy data from 1 worksheet to another based on a condition | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) |