Work Project - Formula help - Multiple sheets

[sjohnson77]

Hi guys ,

Hope you are all well.

I have ran into a major issue with my spreadsheet not pulling the correct data, which is meaning my whole spreadsheet is failing now. I am praying someone on here will be able to help me .

If you look at sheet 1 (attached) You can see that row 4 shows all the financial periods; and row 8 shows all the spend data (sports win). I need a formula that automatically pulls the Financial periods from sheet 1, and then pastes the financial periods onto sheet 2 in column A (so they display like 18P06 (sheet 1 shows = 2018P06) for example. I previously used this formula to successfully pull the data =IF(Sheet1!V7<>0,Sheet1!V7,"") , however this is not working anymore.

I also need the Sports win data (Sheet 1 row 8) to correspond correctly on sheet 2 column E. I previously used the formula =IF(Sheet1!S7<>0,Sheet1!S7,0) for this, but again this has stopped working.

Any help would be greatly appreciated!

Kind regards

 

[etaf]

nothing attached - can you use XL2BB - see menu or my signature to show the spreadsheet - or put onto a known good share like dropbox, onedrive,

 

[sjohnson77]

Unfortunately I cannot use XL2BB as I do not have administrative access on the machine I am on. I have attached the Screenshots, this is the bets I can do for now sorry!