Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Help with Code..or Solution

Wonder if anyone can help.

I have a file which is very labour intensive that needs some automating....I
have what needs automating...now just need some help / advice on this can be
done.

Unfortunately I am not a techie..however I am keen to learn...

I would like to add new staff

i.e. Their Name, Their New Team, Their hours broken down Monday - Sunday
incl Start and Finish Times.

I am more than willing to send this file to anyone who can maybe offer some
help and advice.

Many Thanks in advance.

Kind Regards

Tim

--
Help is always there..youv just got to look for it !
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Help with Code..or Solution

Tim,

Expand a little on what you would want to be automated.

Dave

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Help with Code..or Solution

Thanks dave for the reply.

I have a sheet which holds lots of staff data...however its a big pain to
keep adding and deleting staff..what i would like is like a front end admin
sheet..with like submit boxes on it..that when vales are added they
automatically populate set columes...

I dont know if this is possible.

For example I have a new member of staff Tim Harding who is going on Sarah
Smith's Team he works Monday - Friday 09:00 - 17:00

Could this be done on a front sheet that when the data is typed into the
sheet it is submitted onto the main worksheets in the appropriate
column..does this make sense?.

Thanks again Dave

Tim

"Dave Unger" wrote:

Tim,

Expand a little on what you would want to be automated.

Dave


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Help with Code..or Solution

Tim,

Take a look at DataForm....

Simply put your headings in row 1 then goto DataForm.... You will get a
form that lets you add/delete/update details.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tim Harding" wrote in message
...
Wonder if anyone can help.

I have a file which is very labour intensive that needs some

automating....I
have what needs automating...now just need some help / advice on this can

be
done.

Unfortunately I am not a techie..however I am keen to learn...

I would like to add new staff

i.e. Their Name, Their New Team, Their hours broken down Monday - Sunday
incl Start and Finish Times.

I am more than willing to send this file to anyone who can maybe offer

some
help and advice.

Many Thanks in advance.

Kind Regards

Tim

--
Help is always there..youv just got to look for it !



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
looking for a solution Joe Excel Worksheet Functions 1 December 13th 07 04:37 AM
stubborn Excel crash when editing code with code, one solution Brian Murphy Excel Programming 0 February 20th 05 05:56 AM
Solution for ComboBox Code shashidharga[_2_] Excel Programming 0 October 3rd 04 04:45 AM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"