Automatic Date

neax61ev

New Member
Joined
Jul 30, 2007
Messages
4
Hi,

Is there a way to automatically change the value of all cells in a workbook (or with all open workbooks) with a default value "Date" with a date I want (not necesarily the current date). Please help. Thanks in advance.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Lewiy

Well-known Member
Joined
Jan 5, 2007
Messages
4,284
Welcome to the board!

Just to check, do you really want to change EVERY cell in the workbook to this date value?
 

neax61ev

New Member
Joined
Jul 30, 2007
Messages
4
there are cells in my workbook with a value "Date" which i want to change to change to a date which is required from my report.

I dont want to change all the cells. only the the cells with the word "Date" on it.

Sorry if I cant express my question clearly. we dont use english too often here in KSA.
 

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
2,394
Office Version
  1. 2010
Do you want to change the same cell on each sheet of your workbook to an identical value?
 

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,025
Office Version
  1. 365
  2. 2016

ADVERTISEMENT

Hi There

This sounds like a job for find and replace.

Press Ctrl+H to get it running

In the find box put Date
In the replace box enter the date in question

Then Find All (Check to see if there are any you don't want replaced)
Then Replace All

HTH


Dave
 

neax61ev

New Member
Joined
Jul 30, 2007
Messages
4
No sir, the location of the cell with the word "Date" on it is different in every worksheet on a workbook.
 

neax61ev

New Member
Joined
Jul 30, 2007
Messages
4
Thats what I've been doing Replace. but is there a way to automatically do it, where i'll enter the date I want once and all the cells with a word "Date" on it automatically change. I have around 30 workbooks to change everyday. Thanks
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,026
Messages
5,835,026
Members
430,332
Latest member
Charly_Moon

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