gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,341
- Office Version
- 365
- Platform
- Windows
I have values going down a column on a tab named "WBS" starting on B8
On another Tab named "WBS_Price_Summary" I want to put a forumula; ActiveCell.FormulaR1C1 = "=WBS!R8C2"
in B8 and copy it down the same number of populated rows on the other tab.
So if I have data in B8 through B23 on tab "WBS" I want to instert the formula above in Sheets("WBS_Price_Summary").Range("B8") and then copy the formula down to B23.
Hope that makes sense.
On another Tab named "WBS_Price_Summary" I want to put a forumula; ActiveCell.FormulaR1C1 = "=WBS!R8C2"
in B8 and copy it down the same number of populated rows on the other tab.
So if I have data in B8 through B23 on tab "WBS" I want to instert the formula above in Sheets("WBS_Price_Summary").Range("B8") and then copy the formula down to B23.
Hope that makes sense.