Data Entry Forms //// Profit and Loss account - V. Confusing

troubled

New Member
Joined
Mar 11, 2004
Messages
2
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
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Re: Data Entry Forms //// Profit and Loss account - V. Confu

Welcome to the Board!

Probably the simplest way is to set your form headers in a new sheet, then select Data-->Form. It's Excel's packaged data form. It's not the prettiest in the world, but it's functional.

From there you can use VLOOKUP or SUMIF depending on how your P&L summary is set-up.

Try posting a bit of what you've got so far, using Colo's HTML Maker. You'll find the link at the bottom of the page.

Hope that helps,

Smitty
 

troubled

New Member
Joined
Mar 11, 2004
Messages
2
Re: Data Entry Forms //// Profit and Loss account - V. Confu

It kinda wasnt what i was looking for - I want to actually do the data entry form in excel cells and use formulas and macros to update the profit and loss account.

Does anyone know how to validate a cell in this circumstance?
I want it too only accept data on 4 saturdays a month - This will obviously mean using the date/today function
Because i want excel to update the profit and loss account when i type it in every saturday. This will happen 4 times every month but i dont really understand the date codes etc.

Anyone help?
 

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
Re: Data Entry Forms //// Profit and Loss account - V. Confu

I might have what you want backwards:
Book5
ABCDEFGHIJ
2MonthJanuary
3JanFebMarAprMayJun
4Rev88Rev88102961198484
5Exp69Exp697968887271
6NI19NI192328311213
Sheet3
Book5
ABCDEFGHIJ
2MonthFeb
3JanFebMarAprMayJun
4Rev102Rev88102961198484
5Exp79Exp697968887271
6NI23NI192328311213
Sheet3
Book5
ABCDEFGHIJ
2MonthApril
3JanFebMarAprMayJun
4Rev119Rev88102961198484
5Exp88Exp697968887271
6NI31NI192328311213
Sheet3
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,097
Messages
5,768,071
Members
425,452
Latest member
htay44

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top