Hello,
I am stuck.
I have a series of data that I want to put into a fixed region in a table fomat (96 numbers altogether in an 8 x 12 table) this table will be at the top of the page.
My template below this is a numbering table which will arrange the values in the above described table into columns of four.
For example. If the top table is numbered sequentially from 1-96, 1-8 will go down the first column with the top of the next column starting at 9...etc.
Then for the bottom table, I would like 1-4 in one column, followed by 5-8 in the next column and so forth. Additionally, the bottom template will not always start with number one. I intend to have the bottom template number from one to 40, print out the template, and start another at 41-80, etc. (the numbers wont be 1-96, I just indicated this for simplicity sake)
Is there a way to somehow refer to the formula in the bottom template, rather than the value the formula gives? Example, ,the 1st cell in the bottom template (which is actually cell A16) would be = A1 (first cell in first template). (Thats the easy part) can I somehow make a formula in my bottom template tells the program to indicate the value of the cell in a1, then give the value of the cell right below it, etc? Sort of an auto numbering template based on the top 96 cell data set?
Hopefully I dindt word that too confusing-ly
Thanks![]()
Bookmarks