R
Revenue
I wish I could upload a blank copy of this form so you could tell what
I am looking at.
Basically, a property record is spread over 3 rows of a 48 row form
for each page. There are currently 25 of these report detail pages.
You get 10 properties to a page. Each property has a total of 20 boxes
labeled 11 through 30 (1 to 10 are contained in the page header).
For a given property, we start off with rows 1 and 2 being merged and
centered to form one field in rows A&B. Every other row from 6 through
40 is like that with the rows in between not like that.
Box 9 is contained in column C and it extends the length of all the
property rows on that page, which would be rows 5 through 40. No big
deal comparitively on this portion. Next is where it gets harder.
On the odd number rows, you have these label boxes 11 to 22 on row 1
of each property then boxes 23 through 30 on row 3. For rows 2 and 4
you have the formula driven values for the boxed labels described
above. Just as an example there, the value below box 11 is a merge and
center cell of cell columns F&G, 12 covers columns H&I and 13 covers
J&K, then it goes all the way over to 21 before having the next merge
cell. By the time you get back to box 24, you start with the every
other box gets 2 or more columns, with a few having 3 columns.
The thing is you can get the silly page formatted correctly but then
when you start copying single cell information into an area with
merged and centered columns, you get these messages disallowing this
process. So in order to populate a new page, you may have to tear up
the merge and center columns in order to copy in formulas or whatever
values you need.
What I need is a SIMPLE macro approach to format a whole page at a
time like I just described, without distrubing any populated fields
inside of the page if there are any.
Any ideas?
Thanks,
Bruce
I am looking at.
Basically, a property record is spread over 3 rows of a 48 row form
for each page. There are currently 25 of these report detail pages.
You get 10 properties to a page. Each property has a total of 20 boxes
labeled 11 through 30 (1 to 10 are contained in the page header).
For a given property, we start off with rows 1 and 2 being merged and
centered to form one field in rows A&B. Every other row from 6 through
40 is like that with the rows in between not like that.
Box 9 is contained in column C and it extends the length of all the
property rows on that page, which would be rows 5 through 40. No big
deal comparitively on this portion. Next is where it gets harder.
On the odd number rows, you have these label boxes 11 to 22 on row 1
of each property then boxes 23 through 30 on row 3. For rows 2 and 4
you have the formula driven values for the boxed labels described
above. Just as an example there, the value below box 11 is a merge and
center cell of cell columns F&G, 12 covers columns H&I and 13 covers
J&K, then it goes all the way over to 21 before having the next merge
cell. By the time you get back to box 24, you start with the every
other box gets 2 or more columns, with a few having 3 columns.
The thing is you can get the silly page formatted correctly but then
when you start copying single cell information into an area with
merged and centered columns, you get these messages disallowing this
process. So in order to populate a new page, you may have to tear up
the merge and center columns in order to copy in formulas or whatever
values you need.
What I need is a SIMPLE macro approach to format a whole page at a
time like I just described, without distrubing any populated fields
inside of the page if there are any.
Any ideas?
Thanks,
Bruce