Microsoft Office Questions? Ask a IT Expert for Support ASAP
File ID is File ID: 344228
the issue is I am trying to have the menu items on the menu compendium sheet shaded in green to a column in the COGS page with corresponding unit price and cost as Identify it . Its not working though, not sure why as I can make merged cells on the compendium page equal merged cells on the same page and can make single line merged cells to the COGS page?
Also you will notice that I have it working from COGS to sheet 2?? but not from Compendium to Cogs??
On file ID 295864 I have an issue with the update starting Staff cost button on top left of the P&L page. how this works is that the roster is written at the beginning of the week it populates on the evening cash up sheets next to a cell called Budget under Staff at the bottom. at the end of the week or when the day is finished you should be able to update the P&L page and it should update, but down't could you fix this please and have a look at any other issue or improvements you think could work
Pass word is great91
Yes makes sence however I have tryed this and i the cogs to Sheet 2 example it dosn't matter whether you merges cells it still equals the cell you are pointing??
Try it you will see that in the Compendium to Cogs the #VALUE! error comes up
No have already sent this, however you test the issue??
The target cell is a merged cell and when I type = then choose the cell it chooses the entire group, as it does when you do the same on the same sheet, you will notice that the green cells are copied down the sheet poulating the various menus.
This also dosn't happen for the cogs to sheet 2 for grouped cells??
I don;t understand?
The sheet I pull values from (Compendium) is made up of merged cells?
So why does it work fro Cogs to sheet 2?
I have done this a thousand times and this is the first time this has happened
I just merged some cell on cogs and made it equal merged cells on compendium error occurs?
Have you tryed this?
so why when
I do the same from sheet 2 to cogs and it works, but from Sheet 2 to compenduim it dosn;t?
yes please, as this dosn't make sense to me?