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.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

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,168
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,002
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,822
Messages
5,598,304
Members
414,224
Latest member
Crazy_FC

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