SM... awesome, that's the ticket, you've been a great help. If you would be so kind, there is just one more thing and then I'll leave you alone. Can you show me how I can incorporate your formula with the one below?
=RIGHT(Sheet2!C1,6)
SM... I should have provided a better explanation, your formula works good but not if I use it for other cells. The formula that is in Sheet3 Column A works because it is looking first at C7 in Sheet2 and then incrementing down 7. What do I do for the formula in Sheet3 column B which will be...
Cell A1 has the following in it… =Sheet2!C7, I’m looking for a formula for the cells below A1 that will automatically increment seven cells down, something like this…
A1 =Sheet2!C7
A2 =Sheet2!C14
A3 =Sheet2!C21
A4 =Sheet2!C28 and so on to A2100
Any help is greatly appreciated… thank you