Results 1 to 8 of 8

How would I refer to a formula in a cell rather than the value the formula gives?

Threaded View

gypsyeyes How would I refer to a... 07-09-2008, 02:30 PM
Richard Buttrey Hi, and welcome to the forum.... 07-09-2008, 07:13 PM
gypsyeyes Thanks! 07-10-2008, 09:13 AM
gypsyeyes one more question, please 07-10-2008, 11:47 AM
Richard Buttrey Hi, You could try using... 07-10-2008, 01:13 PM
  1. #1
    Registered User
    Join Date
    10-17-2003
    Posts
    13

    How would I refer to a formula in a cell rather than the value the formula gives?

    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
    Last edited by VBA Noob; 07-09-2008 at 02:32 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1