ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need help creating an attendance worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/129235-need-help-creating-attendance-worksheet.html)

Mitch

Need help creating an attendance worksheet
 
My question is how do I add 1 (A new day) to all the rows of a certain column?

Bob Phillips

Need help creating an attendance worksheet
 
In a free cell, enter a 1 and copy it.

Select all the target cells, goto menu EditPasteSpecial and click Add, and
exit.

Then clear the cell with 1 in it.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mitch" wrote in message
...
My question is how do I add 1 (A new day) to all the rows of a certain

column?




All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com