How to fill selected cells with given data?
Solved/Closed
Related:
- How to fill selected cells with given data?
- How to take screenshot of selected area in excel - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
- How to be offline in whatsapp when data is on - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 26, 2010 at 06:16 AM
Feb 26, 2010 at 06:16 AM
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
Feb 26, 2010 at 07:24 AM
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.
Feb 26, 2010 at 07:59 AM
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.
Feb 26, 2010 at 09:52 AM
Feb 26, 2010 at 12:42 PM
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 SubFeb 26, 2010 at 12:54 PM
I dont know how to thank you enough.