Andrew01
04-24-2012, 02:48 AM
Hi,
I have a peculiar thing happening with my excel spreadsheet, any ideas would be greatly appreciated.
I have two worksheets. The first one has a table that is being populated by a macro.
The second worksheet simply copies the values from the table in the first sheet. eg. I am inputting into the formula line: =Input!A15.
When the macro changes the values in the first sheet I need these to be updated in the second, however the cells in the second sheet change to values and therefore do not update. The formula line no longer says: =Input!A15, but just a value.
I'm really confused. I could send through my macro code but im not sure if it will help? Thanks
I have a peculiar thing happening with my excel spreadsheet, any ideas would be greatly appreciated.
I have two worksheets. The first one has a table that is being populated by a macro.
The second worksheet simply copies the values from the table in the first sheet. eg. I am inputting into the formula line: =Input!A15.
When the macro changes the values in the first sheet I need these to be updated in the second, however the cells in the second sheet change to values and therefore do not update. The formula line no longer says: =Input!A15, but just a value.
I'm really confused. I could send through my macro code but im not sure if it will help? Thanks