How to fill selected cells with given data?
Solved/Closed
Related:
- How to fill selected cells with given data?
- How to copy data from one excel sheet to another - Guide
- Tmobile data check - Guide
- How to reinstall windows 10 without losing data - Guide
- How to delete cells in word - Guide
- How to buy data with fnb sim card - Network Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
26 Feb 2010 à 06:16
26 Feb 2010 à 06:16
Depends on your requirement, If you want to enter todays days, you can press control and ;
I
If the cells location is same and scattered across the sheet, then you can write a macro that looks at those cell and put the date there
I
If the cells location is same and scattered across the sheet, then you can write a macro that looks at those cell and put the date there
26 Feb 2010 à 07:24
My situation is the latter this time, so the cells are scattered all over the sheet and I do not give todays date, usually yesterdays...
I have no idea what that macro would look like.
26 Feb 2010 à 07:59
If cells can be any place in the sheet and each time at a different location, then either you have to type in the date or have to define the address of each cell on a sheet from where macro would know what the address to target.
26 Feb 2010 à 09:52
26 Feb 2010 à 12:42
Here is a macro. Give it a shot, but make sure that you have a backup before hand. Select the target cells first and run the macro
Sub fixDate() Dim vValue As Variant 'default date is yesterday vValue = InputBox("Enter Date", "Date", Date - 1) For Each cell In Selection cell.Value = vValue Next End Sub26 Feb 2010 à 12:54
I dont know how to thank you enough.