hi
sorry for the long time, i use excel to record my greyhound and football records, so i had to add a sheet to test your trigger etc, so 3 profiles and my slow laptop takes a bit of time.
there is one new constant
this is the normal start row if using a new spreadsheet 4
if you delete a row for some reason, then alter the row number
to the next EMPTY row
if you have many records, then it is a good idea to have monthly spreadsheets, so copy the original and rename each one (NOT THE SHEET) with the month name etc.
instructions.
download the trigger
download the excel spreadsheet
first use instructions
open your mfp profile
select Settings (top right of bot screen)
select Excel
UNTICK ALL options
under Custom Cells & Formulae , press Clear All.
save
start of the day instructions
open the spreadsheet
open your mfp profile
press launch excel (top right corner of bet screen)
you should have a confirm message, There is an open instance of Excel. Do you want to connect to that instance?
PRESS Yes
please use test mode until you are happy with your settings
mcbee
download the trigger and spreadsheet below