Using a drop down filter to insert data
Hi all,
I'm trying to speed up the production of a particular report by creating a cover sheet to summarise 6 sheets worth of information.
What I'm trying to create on this front sheet is a drop down box where I can select this month, enter the relevant information and have it populate the other sheets e.g. I select January, insert the data, then select February and repeat.
I know I need a data sheet in the background but my head is spinning trying to get summary sheet to be the central point for data input so that selecting a different month removes all data but still keeps it if that month is selected again.
Any help is much appreciated
Thanks
To select a month from a dropdown and then have that data copied to another sheet will require VBA. I don't think this is a difficult problem but would require a sample workbook to see the specifics of what you are trying to do. The workbook should clearly show what data is to be entered on the main sheet, and where it goes on the destination sheet.
I assume that you have 12 sheets, one for each month, to which the data is to be copied. Other than that, there's no way to assume what is needed.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks