Posted: Sun Oct 05, 2008 11:18 am Post subject: record number each time sheet is opened
I have a spread sheet and when it is opened it will create a new random number (let say in cell d10).
What I want is each time the spread sheet is opened it would get the random number created from cell d10 and then write it to cell "a10" then drop down and write the number to "a11" the next time it is opened.
Basically Keep a history of each random number created when the sheet is opened.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum