trying to create month end report....

S

shane476

Looking to pull an overall report sheet for an individual month from
sheet that lists all data for all months without manually changing cel
references everytime.

Setup for data pages is:
Sales Cost Etc......
Jan
Feb
March
etc......

have seen before where you can have a pull down menu of individua
months which brings up pre programmed references to the correct month
data from the data sheet to make a nice month end report.

Any help greatly appreciated. If any more info is needed, please advis
 
F

Frank Kabel

Hi
have a look at INDIRECT in the help. For the list you may use 'Data -
Validation - List'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with report output....macro??? 1
sum by category, by month 1
Linking to other worksheets 3
Referencing a named range on another sheet 4
Help Needed with Dynamic CountIF 4
how do I average only certain cells based on month? 3
How do I pull data for consecutive months in an Excel spreadsheet 2
Create a 12 month rolling average 15

Top