sjohnson77
New Member
- Joined
- Apr 17, 2021
- Messages
- 11
- Office Version
- 365
- 2019
- Platform
- Windows
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
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