Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell contents to refrenence cells
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
How do I combine the contents of multiple cells in one cell? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions |