ExcelBanter - IF question or MACRO ? Which to use

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF question or MACRO ? Which to use (https://www.excelbanter.com/excel-worksheet-functions/202747-if-question-macro-use.html)

IF question or MACRO ? Which to use

I'm trying to use a "checked Box" , then move information from one page to
another page.
Can I use an IF message or do I need to do a MACRO?
--
Thanks for any help you can provide.
DMK

IF question or MACRO ? Which to use

Formulas cannot move anything so I would assume you need a macro.

Unless you have your formulas on the "another sheet" to pull the data from
the source sheet.

But that won't move it from the source.

Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 12:11:01 -0700, DMK
wrote:

I'm trying to use a "checked Box" , then move information from one page to
another page.
Can I use an IF message or do I need to do a MACRO?

IF question or MACRO ? Which to use

Thanks for the direction,, I can stop trying to use a formula.
Can you give me some help with setting up the macro?

--
Thanks for any help you can provide.
DMK

"Gord Dibben" wrote:

Formulas cannot move anything so I would assume you need a macro.

Unless you have your formulas on the "another sheet" to pull the data from
the source sheet.

But that won't move it from the source.

Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 12:11:01 -0700, DMK
wrote:

I'm trying to use a "checked Box" , then move information from one page to
another page.
Can I use an IF message or do I need to do a MACRO?