Im trying to find a maro that runs constantly looking for changes in another sheet.
ex: if Sheet1 A1 Changes from "1" to "2" I would like the Sheet2 A1 to display this cells value.
Im trying to find a maro that runs constantly looking for changes in another sheet.
ex: if Sheet1 A1 Changes from "1" to "2" I would like the Sheet2 A1 to display this cells value.
this does not sound like you need a macro. in sheet2!A1, type
Formula:Please Login or Register to view this content.
if that doesn't work please upload a sample showing your problem and your desired results.
a b c d =A1&B1&C1&D1
I apologize I should have clarified. I am trying to bring the value of a cell that uses a formula to derive the value shown into the Sheet2 A1 cell so that I can separate the values in Sheet2 A1.
In the example I would try to bring the values in E1 ("abcd") over to Sheet2A1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks