Can anyone give me any advice on creating a data entry form in Excel?
Its going to be a profit and loss account btw
Also,
In the profit/loss part of the account i would like to have it split into months. The data entry will be filled at the end of the week and will automatically go into the month part. I dont know how to make it so the data from the data entry form goes into the correct month. I think its something to do with validation or macros
Can anyone help me? - If u need more info on my question just post again
Keep in mind im an Excel rookie
Its going to be a profit and loss account btw
Also,
In the profit/loss part of the account i would like to have it split into months. The data entry will be filled at the end of the week and will automatically go into the month part. I dont know how to make it so the data from the data entry form goes into the correct month. I think its something to do with validation or macros
Can anyone help me? - If u need more info on my question just post again
Keep in mind im an Excel rookie