Adjust VBA code to paste in a specific area, depending on the sheet that called it
Posted by Lori on November 07, 2001 4:53 AM
I have a macro that filters a lot of data, then copies the filtered data and pastes it into a different worksheet in the same workbook. Right now, it does the Monday worksheet, then Tuesday, Wednesday and so on. Each day's data is pasted into the corresponding row (Monday, Tuesday, ...) of a "Totals" worksheet.
Is there a way to say, "copy the data in the current worksheet and copy it into row 7 if the data is coming from the Monday worksheet, row 8 if it's from the Tuesday sheet, 9 if the Wednesday worksheet, etc."
I can send the code I'm using now if necessary, but it's very long. Thanks in advance to anyone that can help me.