Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mixed Data in column | Excel Discussion (Misc queries) | |||
Excel Template (Creating a Function in the template) | Excel Worksheet Functions | |||
creating mixed dashed and solid line charts | Charts and Charting in Excel | |||
Creating Bespoke Template - how do I bring up a specific data rang | Excel Discussion (Misc queries) | |||
Template for 40-year quarterly cash flow mixed with some monthly flows | Excel Programming |