Is it possible to add range values on a worsheet based on the input on another worksheet, for example, worksheet A has only a range of default values and on worksheet B user adds “New value” on cell A1, is there a way to update the range of values based on what users add on column A, so now the range would contain “New value” as well?
Thanks Amjad for your quick response,
See attached file, that was the long story short, basically there is a page which exports a list of buildings (“Buildings” worksheet) and their properties (“BuildingProperty” worksheet) and the user should be able to add more buildings and their properties, so when a new building is added, it should be shown as an option on the dropdown list at “BuildingName” column on the “BuildingProperty” worksheet, and that dropdown list is being fed by a named range on the “Lookup” worksheet, so I think the only way to show those as new options would be by updating the named range with the newly entered buildings.
So based on your answer I think the easiest solution would be to generate the range with default values plus a bunch of cells having only the formula you provided and just referencing the proper cells on the “Building” worksheet.
Any other idea?