Automatically filling in a formula in a cell

[Guest]

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?

 

[Ron Coderre]

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)

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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.

 

[Guest]

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