dave1414
08-02-2012, 01:29 PM
Hi All,
I need some help/direction with something I'm trying to accomplish. I have an excel workbook with two tabs: 1 tab is a list with the first column containing a number for each row, i.e. 1,2,3,4, etc. The 2nd tab is a drawing, on which I have placed shapes (via Insert > oval). I want to number the shapes (i.e. text box on the shape). I can do all this manually, but ideally I would like the number on the shape in the one tab to be linked to the number in column A in the first tab. In other words, if I change the numbers for each of the rows in column A, it would automatically update the text displayed on the corresponding shape to the new number.
Any thoughts/comments on whether this is doable would be greatly appreciated!
I need some help/direction with something I'm trying to accomplish. I have an excel workbook with two tabs: 1 tab is a list with the first column containing a number for each row, i.e. 1,2,3,4, etc. The 2nd tab is a drawing, on which I have placed shapes (via Insert > oval). I want to number the shapes (i.e. text box on the shape). I can do all this manually, but ideally I would like the number on the shape in the one tab to be linked to the number in column A in the first tab. In other words, if I change the numbers for each of the rows in column A, it would automatically update the text displayed on the corresponding shape to the new number.
Any thoughts/comments on whether this is doable would be greatly appreciated!