Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel 2007 Change Value in Column on Print.?
So I would like to have a form with a fixed amount of rows alotted and in one column it would be the number of entries. I would like the first value in column A to change to +1 of whatever the last entry in that column was everytime the form was printed. Is this possible or is it a pipe dream. So for example if there were 0032 entries in column A when the form was printed the start would be 33 and the end would be 64. If this is complicated please allow me to elaborate.
2 Answers
- AmitLv 68 years agoFavorite Answer
Type 32 into on cell
copy it and Select Cell A1
Right click - select Paste Special....
and Now Select Values and Add
and click ok.
Value of Cell A1 will be increased by 32 (for example if A1 = 1 it will be 33 or A1 = 33 it will be 65)
Shoot the Print can repeat the steps.
This is the simplest method otherwise you will have to take help of Macro.
(°.°)a
Hope this will help you.
Source(s): Self Experience. - 4 years ago
area of your coding has been shrink off so as that's perplexing to assert. yet i could propose making use of the Macro Recorder and going indoors the technique the stairs to attain a similar mandatory effect. Then pass shrink back and edit that macro coding to simplify or make the code greater advantageous suited appropriate to oftentimes used use. If there are adjustments indoors this kind of coding for 2007 the Macro Recorder ought to desire to %. them up.
