Normally I can get by with googling my question (or needs) and find a solution. I'm pretty good at putting stuff together that way but this has me stumped, so I thought I'd stop lurking and reach out for help! Here's my sitch:
Sheet 1 has a user-specified date in cell A1. The rest of Column A (let's say A3:A7) has the names of individuals. Each individual's row has numerous data across multiple columns. (A:Z)
Sheets 2-5 are named after each of the individuals listed in column A in Sheet 1. Column A in Worksheets 2-5 are all the dates in a year. (e.g. 1-Jan-14, etc.)
My goal is to copy the values from each person's row into their respective worksheet on the same row that contains the date specified in cell A1 on Sheet 1.
(Obviously it would loop through all the names until it got to the next empty cell in column A on Sheet 1.)
I already have code written in another part of the workbook to transfer data from one worksheet to another, but in that case I'm specifying which workbook. This is a little different since I need the macro to identify which worksheet each row of information belongs under.
Sheet 1 has a user-specified date in cell A1. The rest of Column A (let's say A3:A7) has the names of individuals. Each individual's row has numerous data across multiple columns. (A:Z)
Sheets 2-5 are named after each of the individuals listed in column A in Sheet 1. Column A in Worksheets 2-5 are all the dates in a year. (e.g. 1-Jan-14, etc.)
My goal is to copy the values from each person's row into their respective worksheet on the same row that contains the date specified in cell A1 on Sheet 1.
(Obviously it would loop through all the names until it got to the next empty cell in column A on Sheet 1.)
I already have code written in another part of the workbook to transfer data from one worksheet to another, but in that case I'm specifying which workbook. This is a little different since I need the macro to identify which worksheet each row of information belongs under.
