sticky problem with paste

[jthomas3029]

I have a workbook with tabbed individual spreadsheets that I now want to consolidate into one sheet. When I copy and paste the individual spreadsheet and paste it on the "master sheet" I lose the functionality of random formulas. The formula is correct and the cell it refers to is formatted correctly but is does not compute it giving me a #value! message. I have checked and rechecked the syntax of the formulas from one that function and the ones that do not and they are the same with he exception of the cell being referenced, Any help with this conundrum will be greatly appreciated.

 

[NdNoviceHlp]

Care to share what the actual formula is? Dave

 

[jthomas3029]

The snap shot XL2BB does not not give a complete picture. Can I send the workbook to you via drop box?

 

[Fluff]

You can upload to dropbox, mark for sharing & then post the link you get to the thread.

 

[NdNoviceHlp]

Thanks Fluff for the direction and removing my post. I just reviewed the rules and was about to report myself. Dave

 

[jthomas3029]

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[NdNoviceHlp]

I think I have it resolved for you. It seems like you have added another year of billing periods to your Table sheet (rows 31 to 54). Your actual personnel sheets have erroneous results in "M" (and "N") as the "M" formula is incorrect but for some reason they produce an erroneous value without erroring. On your master sheet, U need to change the reference to the table sheet data for all of the "M" formulas. So, on the master sheet, for all column "M" formulas, change all of the 30(s) to 54(s). HTH. Dave

 

[jthomas3029]

Well, I am sufficiently embarrassed by the simple solution to correct the formula error. Thank you Dave. I think I was too close to the forest to see the trees. As you said the error was in the two year time span in the table which is good to know as I plan for next years iteration.

 

[NdNoviceHlp]

You are welcome. Thanks for posting your outcome. Dave