Need to paste relative and absolute formula...I think...

Does anyone know if this is possible?

I have a multisheet workbook that I am trying to copy formulas with having to keep manually referencing a certain sheet.

On sheet named "data", I have a formula that is written B4=Jan!B12. It is just equals what ever I input into cell b12 on the January sheet. I need to paste this formula on the same "data" sheet but in cell B39. However I also need it to increase by the next cell down in sheet January. So it should look like this B39=Jan!B13.

I hope I explained this ok...

Thanks for the help!

That is some funny stuff! I think I must have joined the forum when I was working for another company. At the time I was using excel quite a bit. I had forgotten I even was registered until today!

Anyway...

I am still looking to reference the January sheet I just need the next cell down in column B row 13.

When I paste the formula from the "Data" sheet, cell B4 to "Data" sheet B39 it wants to paste the infomation from "january" sheet 34 rows below the cell I need. I am familiar with the $ function. But that holds the formula at "=Jan!B12" I need it to read "=Jan!B13".

I will mess around with what you are recommending and see if I can make sense of it.

Again not sure if I am explaining clearly.

Thanks.

Yes there are formulas in between B4-B39.

Currently this is how I have it set. All of this because of string count limit! Anyway...

Data Sheet:
B4=Jan!B12
B5=Jan!B19
B6=Jan!B26
B7=Jan!B33
and so on until B34 where the last Jan!85 is.

Most of these increase by 7 excepting where the weeks change within the monthly sheets. I have headings and titles that separate the weekly brackets so when it goes to the next bracket(week) it is separated by more than 7 cells.

Now I would like to copy or create a formula that would take the formulas from B4...etc..etc.
and paste it into:

B39=Jan!B13
B40=Jan!B20
B41=Jan!B27
B42=Jan!B34
and so on......

Dredwolf,

Uploaded as is. After seeing this maybe I should explain a bit more so you know what is going on. Or maybe it doesn't matter. Basically the "Monthly-Yearly" sheet is totaling/averaging all of the data from the individual month sheets. However as you will see some of the formulas are pretty long on that worksheet. So I added the "Data" sheet to consolidate, so I could use the "(A1:A20)" type of formula instead of (A1+A2+A3 etc....)

The upper box labeled TIME on the data sheet was done by literally going to each individual box of every month. It was a pain. Hence the reason for wanting to copy and paste...

Sorry about not uploading sooner! Do appreciate your time.

Lydian

Dredwolf,

I think I am getting closer. First off I had to save the new workbook as a workbook with macros enabled. Then I realized I had to use the Insert Function and select user function. I noticed there are 3 different functions that show up. Using the first one the CopyAdd, I am able to insert it into cell B39, have it reference B4 then add 1 which does work. It looks like this B39=CopyAdd(B4,1). The only thing that is not happening is when I make a change to the January worksheet, it is not updating automatically to the data sheet. I have click in the cell that is suppose to have changed then hit enter and it does change.

AWESOME!!!!!! Seems to be working great! I will mess around tomorrow and let you know how I make out...

Thank you!!!!!!!!!!!!!!!!!!!!!

Lydian

Indeed all is well...In fact well beyond!!!

Thanks again Drefwolf for all your help!

Now i am trying to figure out what other information I can have this baby calculate for me.

Indeed all is well...In fact well beyond!!!

Thanks again Drefwolf for all your help!

Now i am trying to figure out what other information I can have this baby calculate for me.