Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling a cell automatically when data is put in another cell. | Excel Worksheet Functions | |||
Filling a cell automatically when data is put in another cell. | Excel Worksheet Functions | |||
how do I stop the cell from filling automatically? | New Users to Excel | |||
Automatically filling in data | Excel Discussion (Misc queries) | |||
filling information from one cell and filling another. | Excel Worksheet Functions |