jaylotheman
New Member
- Joined
- Oct 5, 2011
- Messages
- 7
Hello all, Excel novice user here and complete VBA n00b so please bear with me.
Basically I have a spreadsheet with 4 sheets here:
The first sheet has a table that is meant for a certain user to input values into...once they have inputted all their values (some of which are calculated within that table in the first sheet) I would like them to simply be able to press a button and their values be copied and pasted into the other 3 sheets depending on the value itself and the month selected.
This first sheet has a Month drop-down menu for which the the input user selects and then enters in their data in the table below. Below the table I've added codes which basically join the name of the measure the type of measure and the month selected from the drop-down menu.
The remaining sheets have the measure codes Column A and the Month codes in the rest of the columns, basically what I want the macro (or whatever would work for this copy-paste to occur) to do is look at the code from first sheet and then search for that same code in the other sheets and paste the value into that specific cell (once it finds the appropriate row and column showing that code).
Hopefully this makes sense, I've attached the test file (found in Excel Forum see below for link) I had created showing this example it should be somewhat intuitive, if anyone could help me with this please let me know. And if anyone has questions as to what I'm trying to ask please feel free to let me know that as well, thanks in advance.
Also posted here and attachment file found there: http://www.excelforum.com/excel-programming/795284-need-help-copying-pasting-values-from-one-sheet-to-other-sheets-based-on-codes.html, http://stackoverflow.com/questions/7668435/copying-pasting-values-from-one-sheet-to-other-sheets-based-on-codes
Basically I have a spreadsheet with 4 sheets here:
The first sheet has a table that is meant for a certain user to input values into...once they have inputted all their values (some of which are calculated within that table in the first sheet) I would like them to simply be able to press a button and their values be copied and pasted into the other 3 sheets depending on the value itself and the month selected.
This first sheet has a Month drop-down menu for which the the input user selects and then enters in their data in the table below. Below the table I've added codes which basically join the name of the measure the type of measure and the month selected from the drop-down menu.
The remaining sheets have the measure codes Column A and the Month codes in the rest of the columns, basically what I want the macro (or whatever would work for this copy-paste to occur) to do is look at the code from first sheet and then search for that same code in the other sheets and paste the value into that specific cell (once it finds the appropriate row and column showing that code).
Hopefully this makes sense, I've attached the test file (found in Excel Forum see below for link) I had created showing this example it should be somewhat intuitive, if anyone could help me with this please let me know. And if anyone has questions as to what I'm trying to ask please feel free to let me know that as well, thanks in advance.
Also posted here and attachment file found there: http://www.excelforum.com/excel-programming/795284-need-help-copying-pasting-values-from-one-sheet-to-other-sheets-based-on-codes.html, http://stackoverflow.com/questions/7668435/copying-pasting-values-from-one-sheet-to-other-sheets-based-on-codes
Last edited:
