Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Creating a Template for mixed Data

Hi I have NO knowledge of programming or VBE In Excel, I have several
"command's" that I need to "Automate", as Mouse or Short Cut Buttons, as most
of the Radio Operaters (Volunteer Marine Rescue Radio Log Keeping) will be
out of their depth until now (30 Years) it has been all done by pen and
paper. I have "named and created dropdown "lists" for all the columns A to H
by Validating all except for the ongoing "Real Time" (24Hr) which is Logged
at the start of every new row (4 to 28) as a "Call " comes in which will be a
Key manual entry (ctrl shift ;) for the Template, every new "daily W/sheet
"Template" has the same headings and 2 minor "Name Columns" and 25 Data enry
Rows before a new page is started the latter page must be saved as a legal
Record. is there a book with all the neccessary Codes in it ? I need to know
the Following, Enter Current Day Date inital and Subsequent Pages for that
day at startup (0530 - 1800) Moving Left to Right in the Row's how can I make
the cursor go to the next Charater entry or insertation point or indent,
just by Clicking the Rht Arrow and then drop down to the Next Time entry
Column from say; H4 to A5, then the same after each entry from the "List" of
that Named Column or how do I create or embed these insertion points where I
want to start Typing Data Next that will follow a word or description Eg
D/Date. ........... / How can we Close and Save the inital Sheet and start
another Blank Template Page of several for that day / add and save any new
Data of Vessels Name and Registration Numbers which is C & D, as well as
import the existing Data of Vessels and Reg (600) and List them in 6
Different Alpha Listed and Named Sheets in the Same Workbook. as we are all
Volunteer's we would appreciate any help & advice anyone may have we have to
do all this ourselves as we get only little Gov Assistance" sorry this is so
long. Thanks to all Dasha
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,365
Default Creating a Template for mixed Data

Dasha,

After 24 hours with no replies, looks like there are too many things to deal
with in a single discussion here. Get in touch with me via email (remove
spaces) HelpFrom @ jlathamsite.com and we can discuss putting something
together to provide a solution.

JLatham

"Dasha" wrote:

Hi I have NO knowledge of programming or VBE In Excel, I have several
"command's" that I need to "Automate", as Mouse or Short Cut Buttons, as most
of the Radio Operaters (Volunteer Marine Rescue Radio Log Keeping) will be
out of their depth until now (30 Years) it has been all done by pen and
paper. I have "named and created dropdown "lists" for all the columns A to H
by Validating all except for the ongoing "Real Time" (24Hr) which is Logged
at the start of every new row (4 to 28) as a "Call " comes in which will be a
Key manual entry (ctrl shift ;) for the Template, every new "daily W/sheet
"Template" has the same headings and 2 minor "Name Columns" and 25 Data enry
Rows before a new page is started the latter page must be saved as a legal
Record. is there a book with all the neccessary Codes in it ? I need to know
the Following, Enter Current Day Date inital and Subsequent Pages for that
day at startup (0530 - 1800) Moving Left to Right in the Row's how can I make
the cursor go to the next Charater entry or insertation point or indent,
just by Clicking the Rht Arrow and then drop down to the Next Time entry
Column from say; H4 to A5, then the same after each entry from the "List" of
that Named Column or how do I create or embed these insertion points where I
want to start Typing Data Next that will follow a word or description Eg
D/Date. ........... / How can we Close and Save the inital Sheet and start
another Blank Template Page of several for that day / add and save any new
Data of Vessels Name and Registration Numbers which is C & D, as well as
import the existing Data of Vessels and Reg (600) and List them in 6
Different Alpha Listed and Named Sheets in the Same Workbook. as we are all
Volunteer's we would appreciate any help & advice anyone may have we have to
do all this ourselves as we get only little Gov Assistance" sorry this is so
long. Thanks to all Dasha

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Creating a Template for mixed Data

Thanks Very Much to JLathem for your time and generosity it will be well
remembered and I will contact you today Thanks again,

"JLatham" wrote:

Dasha,

After 24 hours with no replies, looks like there are too many things to deal
with in a single discussion here. Get in touch with me via email (remove
spaces) HelpFrom @ jlathamsite.com and we can discuss putting something
together to provide a solution.

JLatham

"Dasha" wrote:

Hi I have NO knowledge of programming or VBE In Excel, I have several
"command's" that I need to "Automate", as Mouse or Short Cut Buttons, as most
of the Radio Operaters (Volunteer Marine Rescue Radio Log Keeping) will be
out of their depth until now (30 Years) it has been all done by pen and
paper. I have "named and created dropdown "lists" for all the columns A to H
by Validating all except for the ongoing "Real Time" (24Hr) which is Logged
at the start of every new row (4 to 28) as a "Call " comes in which will be a
Key manual entry (ctrl shift ;) for the Template, every new "daily W/sheet
"Template" has the same headings and 2 minor "Name Columns" and 25 Data enry
Rows before a new page is started the latter page must be saved as a legal
Record. is there a book with all the neccessary Codes in it ? I need to know
the Following, Enter Current Day Date inital and Subsequent Pages for that
day at startup (0530 - 1800) Moving Left to Right in the Row's how can I make
the cursor go to the next Charater entry or insertation point or indent,
just by Clicking the Rht Arrow and then drop down to the Next Time entry
Column from say; H4 to A5, then the same after each entry from the "List" of
that Named Column or how do I create or embed these insertion points where I
want to start Typing Data Next that will follow a word or description Eg
D/Date. ........... / How can we Close and Save the inital Sheet and start
another Blank Template Page of several for that day / add and save any new
Data of Vessels Name and Registration Numbers which is C & D, as well as
import the existing Data of Vessels and Reg (600) and List them in 6
Different Alpha Listed and Named Sheets in the Same Workbook. as we are all
Volunteer's we would appreciate any help & advice anyone may have we have to
do all this ourselves as we get only little Gov Assistance" sorry this is so
long. Thanks to all Dasha

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,365
Default Creating a Template for mixed Data

Email received and replied to - we'll just take this off line since it is
closer to a full development project than just a specific request in one
particular area.

"Dasha" wrote:

Thanks Very Much to JLathem for your time and generosity it will be well
remembered and I will contact you today Thanks again,

"JLatham" wrote:

Dasha,

After 24 hours with no replies, looks like there are too many things to deal
with in a single discussion here. Get in touch with me via email (remove
spaces) HelpFrom @ jlathamsite.com and we can discuss putting something
together to provide a solution.

JLatham

"Dasha" wrote:

Hi I have NO knowledge of programming or VBE In Excel, I have several
"command's" that I need to "Automate", as Mouse or Short Cut Buttons, as most
of the Radio Operaters (Volunteer Marine Rescue Radio Log Keeping) will be
out of their depth until now (30 Years) it has been all done by pen and
paper. I have "named and created dropdown "lists" for all the columns A to H
by Validating all except for the ongoing "Real Time" (24Hr) which is Logged
at the start of every new row (4 to 28) as a "Call " comes in which will be a
Key manual entry (ctrl shift ;) for the Template, every new "daily W/sheet
"Template" has the same headings and 2 minor "Name Columns" and 25 Data enry
Rows before a new page is started the latter page must be saved as a legal
Record. is there a book with all the neccessary Codes in it ? I need to know
the Following, Enter Current Day Date inital and Subsequent Pages for that
day at startup (0530 - 1800) Moving Left to Right in the Row's how can I make
the cursor go to the next Charater entry or insertation point or indent,
just by Clicking the Rht Arrow and then drop down to the Next Time entry
Column from say; H4 to A5, then the same after each entry from the "List" of
that Named Column or how do I create or embed these insertion points where I
want to start Typing Data Next that will follow a word or description Eg
D/Date. ........... / How can we Close and Save the inital Sheet and start
another Blank Template Page of several for that day / add and save any new
Data of Vessels Name and Registration Numbers which is C & D, as well as
import the existing Data of Vessels and Reg (600) and List them in 6
Different Alpha Listed and Named Sheets in the Same Workbook. as we are all
Volunteer's we would appreciate any help & advice anyone may have we have to
do all this ourselves as we get only little Gov Assistance" sorry this is so
long. Thanks to all Dasha

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
Mixed Data in column Greg Excel Discussion (Misc queries) 5 July 17th 09 05:32 PM
Excel Template (Creating a Function in the template) Té Excel Worksheet Functions 3 March 6th 09 07:17 AM
creating mixed dashed and solid line charts nathanhutto Charts and Charting in Excel 1 November 9th 07 06:26 PM
Creating Bespoke Template - how do I bring up a specific data rang Peterwnixon Excel Discussion (Misc queries) 0 January 2nd 07 12:37 PM
Template for 40-year quarterly cash flow mixed with some monthly flows janderson Excel Programming 1 December 3rd 05 10:44 AM


All times are GMT +1. The time now is 06:50 PM.

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"