greetings all,
i have a problem that i hope you can help me with. i have a workbook with 4 sheets. On three of the sheets, there are products and prices that could be entered into rows on sheet7, sheet5, sheet4 as noted below. data will always be inputted from top to bottom on these rows.
Data inputted onto sheet7, sheet5 or sheet4 needs to copy over onto sheet2 starting at sheet2 - L2:M2 and then subsequent entries will advance to the next row.
Data will be inputted onto these three sheets at specified rows starting with top row and incremening down. there is a possiblily that all three sheets will have data inputted into the specified areas at any given time. Each sheet will have 15 rows and each row will have two columns of data.
Sheet7 L31:M45 copied data will not be cleared
Sheet5 E5:F19 copied data will not be cleared
Sheet4 L31:M45 copied data will not be cleared
Data needs to be copied over to the following sheet:
Sheet2 L2:M16
there will never be a need for more than 15 rows that will need to be copied over to sheet2
I have attached a sample worksheet to illustrate.
thanks in advance for you time and assistance!
Bookmarks