Excel Worksheet 1

[alexm999]

I'm new to excel and have been given a task to complete.
I've created a marketing excel file that lists the following information.
Store #
Customer Name
Loan Amount
Loan Date
Multiple Loan
How did you hear about us

Now that i've inputed the 700 or so records and everything is fine, my bosses want to be able to have other people add records (information above) into the excel worksheet. What's the easiest and quickest way this can be done? I was thinking about using HTML to have users type in fields and it somehow updates the excel file automatically. My email is alex.markovich@comcast.net

Any ideas?

 

[Loomah]

Hi Alex
There are a couple of ways you could approach this
1)Your users could enter data directly into the worksheet under the last record
2)You could use Excel's built in data form - Go DATA>FORM...
3)Create your own form. This to me would be the best method but would need some programming.

I'm not sure I'll be able to follow this up but if you post a little more detail if the above suggestions (1 & 2) are of no use I'm sure someone else would pick up the baton.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[Chattin]

Check out John Walkenbach's enhanced data form also

http://j-walk.com/ss/dataform/index.htm

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[alexm999]

I have an excel spreadsheet that has the following:
Store#
CustomerName
FirstLoanDate
FirstLoanAmount
HowDidYouHearAboutUs

I need help writing an HTML file that if someone types in data for the fields above, it will automatically update the main excel file that has all the recordds...

 

[xlbo]

This isn't a helpdesk - there is no point in just restating a question. If you need help, at least show you have tried to make some headway within your chosen option or at least show you have considered the replies already posted...

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[alexm999]

I understand that this is not a help desk, but I need assistance. I've tried creating an HTML file that will add a record to the main excel file, but i just can't seem to get the code correct. I just need 'HELP' at this point.

Sorry if some of us are new to programming.

 

[xlbo]

well - could you post your current code then - that would've prevented my last post as it shows you're trying to help yourself as well

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[smurf01]

Alex,
Do you have some sample data, I have a form that i created for some users it might be of use to you. E-mail at tpo@btinternet.com


Regards

Paul

 

[alexm999]

I have a sample data, i will be emailing it to you... thank you!

 

[smurf01]

Alex, I have sent you some sample data let me know what u think

Regards

Paul

 

[ashishbs]

Hi Alex,

I guess i have a simple solution.
Steps :-
1> Open Your Workbook (What has all those 700 odd records).

2> In the Menu -- Click --> Tools --> Share Workbook --> Check the box what says "Allow Changes by more than One User"

3> Click the Advanced TAB, For Keep History , I'll suggest keep less Number of days (to keep the file size less)

4> Click File --> Save As (And Save the file on a Shared Drive where everybody can access).

I Hope this solves your purpose.

Feel free to Contact me.

Ashish