Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 02-18-2015, 12:00 PM   #1
In Runtime
 
Join Date: Aug 2014
Location: UK
Posts: 303
Default Help with Microsoft Excel 2010

I am looking for a little help please.

I am the treasurer of the local cricket club and I have just prepared a form for use with our banking.

It is a very simple form and just allows the person who has done the banking to itemise the amount banked, what the money is for and, the date that it was banked.

What I am looking to do is, to send the form by email to those involved and, for them to be able to complete the form on their pc/laptop whatever and then email it back to me.

For instance, there is a space for the date which I have inserted as dd/mm/yyyy, there is a column for the detail and, another for the amount banked.

My question is, when they receive the form will they be able to make their entrIes, i.e. edit the form or, will it be locked in any way? If it would be locked, what do I do to set it up the way I want it used please?
Once they have a copy of the form I want them to be able to use it time and time again and so, when they enter the date for instance, I need it to return to showing dd/mm/yyyy. I hope that this all makes sense.

Many thanks.
__________________

bluenose1940 is offline   Reply With Quote
Old 02-18-2015, 02:36 PM   #2
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 1,943
Default Re: Help with Microsoft Excel 2010

Using an Excel spreadsheet as a form to do what you want seems like overkill. Do all these people have Excel on their computers?

Why not simply have them send you an email with the info you need?
__________________

strollin is offline   Reply With Quote
Old 02-19-2015, 05:05 AM   #3
Fully Optimized
 
joedaman633's Avatar
 
Join Date: Apr 2012
Location: England, Birmingham
Posts: 1,812
Default Re: Help with Microsoft Excel 2010

Looks like he wants all the entries in a file strollin, so to store the data it might be easier to use the excel file.

It shouldn't be locked bluenose, they just need to save it to their pc, modify it, and send it back to you (and make sure it's the version with the latest information!)
__________________
Athlon II x4 645 || 1TB 7200rpm HDD || EVGA GTX 650Ti OC || 8GB DDR3 RAM || Windows 7 Home x64

i5 4210M || 500GB Samsung EVO 850 SSD || GeForce 825M || 16GB DDR3 RAM || Windows 10 x64
joedaman633 is offline   Reply With Quote
Old 02-19-2015, 10:08 AM   #4
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 1,943
Default Re: Help with Microsoft Excel 2010

If that's the case, it would be better to have only 1 spreadsheet, shared someplace like in Google docs, that everyone accesses and adds their entries to. Emailing a spreadsheet back and forth is crazy.
strollin is offline   Reply With Quote
Old 02-19-2015, 10:37 AM   #5
..m.0,0.m..
Site Team
 
iPwn's Avatar
 
Join Date: May 2010
Location: USA
Posts: 3,870
Default Re: Help with Microsoft Excel 2010

Quote:
Originally Posted by strollin View Post
If that's the case, it would be better to have only 1 spreadsheet, shared someplace like in Google docs, that everyone accesses and adds their entries to. Emailing a spreadsheet back and forth is crazy.
+1 to this post!

It seems like such a simple thing to manage... sending an 'up-to-date' spreadsheet back and forth, but it only takes one person to make changes, not save them, and send it in to cause a financial nightmare come reconcile when you can't figure out where the missing entries are...
__________________
Me: You'd think as the dominant species we wouldn't be so effing stupid.
J: We're just intelligent enough to be completely effing stupid.
iPwn is offline   Reply With Quote
Old 02-20-2015, 07:27 AM   #6
In Runtime
 
Join Date: Aug 2014
Location: UK
Posts: 303
Default Re: Help with Microsoft Excel 2010

Thanks for the input folks. Would it be possible for me to attach the 'form' to a post on here so that you could have a look at it and to see what I am trying to do.
Please have it in mind that you are dealing with a 75 year old wrinkly here!

Thanks again for the help thus far.
bluenose1940 is offline   Reply With Quote
Old 02-20-2015, 08:31 AM   #7
Fully Optimized
 
joedaman633's Avatar
 
Join Date: Apr 2012
Location: England, Birmingham
Posts: 1,812
Default Re: Help with Microsoft Excel 2010

75 years young!
__________________

__________________
Athlon II x4 645 || 1TB 7200rpm HDD || EVGA GTX 650Ti OC || 8GB DDR3 RAM || Windows 7 Home x64

i5 4210M || 500GB Samsung EVO 850 SSD || GeForce 825M || 16GB DDR3 RAM || Windows 10 x64
joedaman633 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 01:43 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0