I have 6 sheets in one workbook
Sheet 1 is main sheet
Sheet 2 Vendor A
Sheet 3 Vendor B
I am think to solve like this,
If I enter in Sheet 1, A2 'P' then data enter in Sheet 2, A2
If I enter in Sheet 1, A3 'B' then date enter in Sheet 3, A2
If I enter in Sheet 1, A4 'P' then data enter in Sheet 2, A3
If I enter in Sheet 1, A5 'P' then date enter in Sheet 2, A4
If I enter in Sheet 1, A6 'B' then date enter in Sheet 3, A3
PLEASE HELP
Bookmarks