Hello,
I have my daily collection and exp. in a excel file.
I have 12 Sheets in a workbook, named 12 months of a year.
and each sheet have 31 rows according dates of this month.
and each sheet have 5 coloumns 'Date' 'Particulars' 'Dr' 'Cr' 'Balance'
When I want to add a new entry on current date or want to modify
an earlier date. I must spent more time to search exact row and column.
So I think for create a link on each sheet 'Go To Today' ; but I have no idea
for do that.
Can you help me?
Thanks in advance.
I have my daily collection and exp. in a excel file.
I have 12 Sheets in a workbook, named 12 months of a year.
and each sheet have 31 rows according dates of this month.
and each sheet have 5 coloumns 'Date' 'Particulars' 'Dr' 'Cr' 'Balance'
When I want to add a new entry on current date or want to modify
an earlier date. I must spent more time to search exact row and column.
So I think for create a link on each sheet 'Go To Today' ; but I have no idea
for do that.
Can you help me?
Thanks in advance.