Macros & Copying to another sheet

  • Thread starter Thread starter Danie.Bright
  • Start date Start date
D

Danie.Bright

Okay i have a workbook with 3 sheets -
1st has a form
2nd has a continuation of the first form
3rd is a database for drop downs on the first sheet (otherwise
irrelevant to this question)

okay on all the regular/simple text cells/ easily formulated cells, i
am able to have those copied on to page 2 easily using a formula such
as (to copy contents of Page 1 A1 to Page 2 A1)
='Page 1'!a1 or =IF(ISBLANK('Page 1'!A1),"",'Page 1'!A1


however in say cell B2 (Page 1) i have a Macro's set up to populate a
certain phrase/disclaimer (text) in that cell when prompted by the
macro's key. that works fine - but if page 1 B2 is populated i want
page 2 B2 to be populated with the same information (now of course i
could click page 2 & do the macro's key there - but that isnt the
goal- the goal is to fill out page 1 and it populate/copy onto page
2).

however when i enter in one of the above formulas (ISBLANK, actually)
i get an error message, like the formula cannot read page 1 B2 cell
because it is not plain text???

is there anything i can do about this?
 
i'm not sure which code you mean. it is a regular macro's (tools-
macros-record new macros) on Page 1
the code used on page 2 to copy is below. =IF(ISBLANK('Page 1'!
B2),"",'Page 1'!B2)
 
Back
Top