I have two sheets in a workbook in Excel; "Sheet1" and "Sheet2". Sheet1 has a lot of data that will be changed, and shee2 has two active cells. These cell equal whatever is in the first two cells of on the other page. That is, if (A1 & A2) on sheet1 equal (3 & 5) then on sheet2 they will equal the same thing. Right, so as for the Excel VBA part. I making a macro that creates "sheet2" . so the macro needs to take Range "A1:A2" from "sheet1: and put them at Range"A3 & A4" on sheet2. So, when the value on sheet1 A1 changes, then on sheet2 A3 it will also change.
I just want to know how to copy the dynamic value of a cell on another sheet. Is this possible, because I swear the closest thing I can find is a vlookup
and that just seems to complicated for such an easy task, and I'm not even sure that would work.
TL;DR How copy dynamic value of cell from another sheet with no vlookup
in VBA?
No comments:
Post a Comment