Hi everyone, I'm new to this forum and just looking for some help.
I'll try to explain it as best I can but please let me know if you require any more information. I'm slowly learning formulae for excel and a little on Google Sheets. Normally when I need help I just Google what I'm after and I know enough to be able to adapt the formulae to what I need it for, no luck this time.
On one sheet I have my Job Numbers, which in the "Test Excel" file I have in Dropbox is incomplete but has the general idea of what I'm looking to do. The other sheet is a Look Ahead Schedule that I want to populate based on the information on the Job Numbers sheet. But I only want certain jobs to be carried over, so I have a column that when filled with an "X" will fill out my Look Ahead Schedule but if the job in Job Numbers doesn't have an "X" in the column the Look Ahead Schedule registers a blank cell. I'm wating to remove the blank cells or use a different formulae so it doesn't put blank cells on the Look Ahead Schedule. (By blank cells I mean empty cells with the formulae in it)
The formulae I'm using currently is:
=IF('Job Numbers'!B3="X",'Job Numbers'!A3,"")
And then change the cell references in that formulae for some other columns.
Here is the Dropbox link:
https://www.dropbox.com/s/pue0wg5568...xcel.xlsx?dl=0
The actual Job Numbers list is over 400 cells long so I tried to make it less clustered with a new test file.
Any help, even if its a link to another forum post would be great and sorry if it has already been asked, I couldn't find anything on here or the many Google searches I tried.
Thanks in advance.
Bookmarks