Suggest about Cell Reference

gdharsh

New Member
Joined
Mar 7, 2009
Messages
1
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.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,836
Office Version
  1. 2019
Platform
  1. Windows
Hi, Welcome.

1) I recommend for dates, even if you want them to appear as only a month or day value, to use full dates.

2) Then a FIND will work: Control + F, enter the date to be found, and Excel will take you right there (assuming you don't have dates all over the place in other ways).

---------------------

Regarding #1 above, use formatting (Control + 1) so that the date displays how you like, but (internally) is stored as the full date.

But really, it shouldn't be hard to find the date...click the tab for the month, then there's only 31 days to choose from? Almost any other action would take as long too.

---------------------

Or if you can, best of all to keep the data all on one sheet. Its always easier to work with data in a discrete dataset or grid, rather than on multiple tabs. Separate the data entry and data collection from reporting the data whenever possible - the former optimized for effective processing and storage, and the latter for appearance and the end users needs.

Alex

As an example:

The following cells all contain the same Date 01-JAN-2009
book1
ABCD
1DateCustomFormat
231-01-2009dd-mm-yyyy
3January31,2009mmmmd,yyyy
431d
5Satddd
631-01dd-mm
701-31mm-dd
81m
901mm
10Janmmm
11Januarymmmm
Sheet1
 
Last edited:
Upvote 0

Forum statistics

Threads
1,195,664
Messages
6,011,023
Members
441,579
Latest member
satishrazdhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top