I'm looking for a macro (or a formula- whichever is easier) that will copy and paste a range of cells from one worksheet to another based on a criteria listed on the second worksheet.
For example, in worksheet "Input sheet", cell C6 entry is either "Single", "Married, Joint", "Married, Separate", or "Head of Household". The appropriate entry is selected from a drop-down menu. Another worksheet called "List" in the same workbook has a table (which has numbers and percentages) corresponding to each of the 4 entries. For now, these tables are pasted below each other, but I can change that easily if needed. Each table has same column headings, and tax%, just different title and numbers. A sample table looks like this:
Sorry- the pasted table is not formatted the way it should be. Basically it's 3 columns and 7 rows (C4:E10)the col headings are Lower Limit/ UpperLimit/ and Tax% The name of this table is Single.
Any help would be appreciated! Thanks so much