Automatically filling in a formula in a cell
 

I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?
--
Don

Automatically filling in a formula in a cell
 

Try this:

From the Excel Main Menu:
<tools<options<edit tab....CHECK: Extend data range formats and formulas


Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Don" wrote in message ...
I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?
--
Don

Automatically filling in a formula in a cell
 

Already tried that ... didn't work ... thanks
--
Don


"Ron Coderre" wrote:

Try this:

From the Excel Main Menu:
<tools<options<edit tab....CHECK: Extend data range formats and formulas


Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Don" wrote in message ...
I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?
--
Don

Automatically filling in a formula in a cell
 

Right-click on the sheet and "View Code".

Any Worksheet_Change event code that could be doing the deed?

If nothing, right-click on the Excel icon left of "File" and "View Code"

Anything in there?


Gord Dibben MS Excel MVP

On Mon, 22 Oct 2007 09:31:01 -0700, Don wrote:

I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?

Automatically filling in a formula in a cell
 

There's no code that could be doing ... at least that I can find. I don't
know what a Worksheet_Change Event is.
--
Don


"Gord Dibben" wrote:

Right-click on the sheet and "View Code".

Any Worksheet_Change event code that could be doing the deed?

If nothing, right-click on the Excel icon left of "File" and "View Code"

Anything in there?


Gord Dibben MS Excel MVP

On Mon, 22 Oct 2007 09:31:01 -0700, Don wrote:

I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?

Automatically filling in a formula in a cell
 

Your post threw me with "will automatically fill in
a formula in column A"

Maybe you meant "automatically fill in a value in column A"?

Are there formulas in Column A that look like this or similar?

=IF(B1="","",B1) which says.....if B1 is empty, leave A1 looking blank
otherwise enter B1 contents.


Gord

On Mon, 22 Oct 2007 11:09:03 -0700, Don wrote:

There's no code that could be doing ... at least that I can find. I don't
know what a Worksheet_Change Event is.
--
Don


"Gord Dibben" wrote:

Right-click on the sheet and "View Code".

Any Worksheet_Change event code that could be doing the deed?

If nothing, right-click on the Excel icon left of "File" and "View Code"

Anything in there?


Gord Dibben MS Excel MVP

On Mon, 22 Oct 2007 09:31:01 -0700, Don wrote:

I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?

Automatically filling in a formula in a cell
 

No. It's a totally blank cell that fills with
=CONCATENATE(MONTH(B1892),"-",YEAR(B1892)) after a date is inserted in the
row in column B. I've looked for conditional formating, macros, and made
sure auto extentions is enabled. It makes no sense (at least to me), but
it's doing it.
--
Don


"Gord Dibben" wrote:

Your post threw me with "will automatically fill in
a formula in column A"

Maybe you meant "automatically fill in a value in column A"?

Are there formulas in Column A that look like this or similar?

=IF(B1="","",B1) which says.....if B1 is empty, leave A1 looking blank
otherwise enter B1 contents.


Gord

On Mon, 22 Oct 2007 11:09:03 -0700, Don wrote:

There's no code that could be doing ... at least that I can find. I don't
know what a Worksheet_Change Event is.
--
Don


"Gord Dibben" wrote:

Right-click on the sheet and "View Code".

Any Worksheet_Change event code that could be doing the deed?

If nothing, right-click on the Excel icon left of "File" and "View Code"

Anything in there?


Gord Dibben MS Excel MVP

On Mon, 22 Oct 2007 09:31:01 -0700, Don wrote:

I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?

Automatically filling in a formula in a cell
 

It sounds as if there has to be some underlying code on the worksheet.

--Right CLick the tab for the worksheet at the bottom and select view code
--This will open up the VBA code area
--If there is nothing there, on the left there is the VBA project window,
click through each worksheet and the workbook.
--You may also need to change the drop down above the code area to find the
code that is doing this for you.

Hope this helps
--
<<Thanks


"Don" wrote:

I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?
--
Don