I've only a rudimentary knowledge of Excel and want to do the following.
Have 3 spreadsheets - either 3 individual files or one file with different pages - would prefer individual files.
Sheet 1:
Information is entered into a line and at the end of the line is a Yes/No answer.
If it's no, do nothing. If it's yes but that line where specified on Sheet 3.
Sheet 2:
Same again. Yes/no answer governs if and when the information is copied onto sheet 3.
The idea is that sheet 1 is a job book, sheet 2 is a payment book and when the job is completed, it updates sheet 3 and then when the job is paid, it also updates sheet 3.
Is this possible?
I'm guessing Access could do this also? - I put together a simple waiting room system in college but that was a few years ago. Would be cool to automate it all with buttons and what not to make it easier to use.
Have 3 spreadsheets - either 3 individual files or one file with different pages - would prefer individual files.
Sheet 1:
Information is entered into a line and at the end of the line is a Yes/No answer.
If it's no, do nothing. If it's yes but that line where specified on Sheet 3.
Sheet 2:
Same again. Yes/no answer governs if and when the information is copied onto sheet 3.
The idea is that sheet 1 is a job book, sheet 2 is a payment book and when the job is completed, it updates sheet 3 and then when the job is paid, it also updates sheet 3.
Is this possible?
I'm guessing Access could do this also? - I put together a simple waiting room system in college but that was a few years ago. Would be cool to automate it all with buttons and what not to make it easier to use.