jmarshall2014
New Member
- Joined
- Nov 18, 2014
- Messages
- 1
Hi Guys,
I'm not an Excel guru, so forgive my ignorance. I have created a simple macro that references cells on various sheets and creates a summary table that provides completed sales against quota. I'd just like to update a few cell references in the macro, but it seems that the cells I would expect to see do not show up when I search through the macro. When I recorded the macro, I clicked on specific cells to pull into the new summary sheet, and the report works correctly.
Here is some supporting info from my macro:
Range("F18").Select
ActiveCell.FormulaR1C1 = "='NA SPS Prod'!R[57]C[-2]"
The F18 cell is the location in my new worksheet where the imported cell is pointing. NA SPS Prod is the correct worksheet from where I want to grab the data for new cell F18. I have no idea what R[57]C[-2] means however. R57 in the NA SPS Prod sheet is not the cell that I referenced when recording the macro. The column R seems correct, but "57" and "-2" aren't making sense to me. I would expect to see the macro show the same cell reference as I can see in the new sheet.
Please let me know if this makes sense and if you have any guidance.
I'm not an Excel guru, so forgive my ignorance. I have created a simple macro that references cells on various sheets and creates a summary table that provides completed sales against quota. I'd just like to update a few cell references in the macro, but it seems that the cells I would expect to see do not show up when I search through the macro. When I recorded the macro, I clicked on specific cells to pull into the new summary sheet, and the report works correctly.
Here is some supporting info from my macro:
Range("F18").Select
ActiveCell.FormulaR1C1 = "='NA SPS Prod'!R[57]C[-2]"
The F18 cell is the location in my new worksheet where the imported cell is pointing. NA SPS Prod is the correct worksheet from where I want to grab the data for new cell F18. I have no idea what R[57]C[-2] means however. R57 in the NA SPS Prod sheet is not the cell that I referenced when recording the macro. The column R seems correct, but "57" and "-2" aren't making sense to me. I would expect to see the macro show the same cell reference as I can see in the new sheet.
Please let me know if this makes sense and if you have any guidance.
