Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking cells in a column (result) to cells in a row (source)
MS XP Pro / Excel 2007:
Good day all. I have data in two consecutive rows. The 1st one is text and the second contains formulae which results in values. (Call these the "source") On another sheet in the same workbook I have two columns (Call these the destination) which need to be linked to the source rows if value (other than zero) is present in the 2nd source row. There could be zero value or blank cells within the source rows. I need code to sequentially seek values (other than zero) in the cells in the 2nd row of the source and when found, the next available cell in the destination column needs to be linked to the one found so as to dynamically update the values in both rows to these these two columns. The next time the code is run there could be different cells to be linked. i.e. the previous links would be replaced by the current ones. I think some kind of loop??? I hope that my question is clear. Can anyone assist with the code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking cells in a column (result) to cells in a row (source)
How are the formulas being put into the ffirst column. If it is in a macro then this macro need to be modified to add the link at the same time to the second column. It is difficult to look at a formula and determine which cells arre referenced by the formula. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186557 Excel Live Chat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Cells, Incorrect Result | Excel Worksheet Functions | |||
Linking Cells -- Keep Source Cell's Formatting | Excel Discussion (Misc queries) | |||
Linking cells between worksheet - from column to row | Excel Worksheet Functions | |||
Linking cells: open source to update values | Excel Discussion (Misc queries) | |||
How do I quickly fill a formula result into a column of cells? | Excel Worksheet Functions |