Hello All,
I have identical tables on two separate tabs, but they get their data from different places via external references. The table in tab A has values of store A and tab B has values of store B.
When I record a macro on tab A and then I try to run it on tab B, it uses the values from tab A at copy paste functions, i.e. pastes values from tab A (store A`s data) into tab B. I have not had this issue before. Earlier when I ran macros they did not take the references from the tab on which I recorded them. Maybe something has changed in the basic settings of my Excel? Can anyone help me with this problem?
Thank you.
Bookmarks