Cell contents to refrenence cells

S

slowjam4

Hi,
I have a worksheet1 with the following contents:

Cell A1 = "C3"
Cell B1 = "123.45"
Cell A2 = "D5"
Cell B2 = "333.12"
Cell A3 = "B12"
Cell B3 = "34.99"
..
..
..

I would like to write a macro to move worksheet1 Cell B1("123.45") to
worksheet2 Cell C3 and move worksheet1 Cell B2("333.12") to worksheet2
Cell D5 ... and continue doing this until the last row with data is
encountered on worksheet1.

In other words use the contents of worksheet1, column A to determine
which Cell to reference on worksheet2.

Can someone help me with this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need a cell to be blank. 4
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Using cell value to reference another cell 2
How do I use the text content of a cell as a worksheet reference? 9
Need help calculating probabilities 7
DBSUM function but with function as criterion, not a range 3
sorting through unknown source data as it is entered 1
convert vlookup formula to link formula 0

Top