Posted by Mark on February 06, 2002 9:02 AM
I have a spreadsheet, called #1, with 12 columns representing the months of the year, Jan. thru Dec. Here is my problem.. Take the month of January, for example, I am wanting to pull about a dozen numbers from a very, very large spreadsheet and pull them onto the #1 spreadsheet which will give us exactly what we are wanting to see. So, January comes out fine, but how do I copy the formulas over to Feb., March, April etc. and get the formulas to pull from their respective month?? I want my Feb. formulas to pull from the Feb. worksheet, but when I copy the formulas from January to February the formulas are still reading the data as January, not February?? Confused? Me Too!! Help!!!