Help, please!
I have two sheets. One with flights to bill and the other one with billed flights
Sheet1
po#, Status, Start Flight, End Flight, Contract Amt, Diff, Last Month Billed
1668 Complete 5/2 5/23 $57,223 $0 May 2011
1570 Due in Jun 1/5 6/23 $158,721 $71,748 May 2011
Sheet2
po# Inv Date Billed Run Date
1668 5/23/11 $57,223.18 May 2011
1570 4/30/11 $23,916.00 January 2011
1570 5/30/11 $23,916.00 February 2011
1570 6/23/11 $23,916.00 May 2011
What I want to populate is: #1 "Last Month Billed" this will go to sheet1 under last month billed and it will pull the information from sheet2, under "Run Date".
#2 I also, want to put its latest status "billed in full", or "due in June" and this will be calulated from "the flight dates" and "last month billed".
Thank you guys!!!
I have two sheets. One with flights to bill and the other one with billed flights
Sheet1
po#, Status, Start Flight, End Flight, Contract Amt, Diff, Last Month Billed
1668 Complete 5/2 5/23 $57,223 $0 May 2011
1570 Due in Jun 1/5 6/23 $158,721 $71,748 May 2011
Sheet2
po# Inv Date Billed Run Date
1668 5/23/11 $57,223.18 May 2011
1570 4/30/11 $23,916.00 January 2011
1570 5/30/11 $23,916.00 February 2011
1570 6/23/11 $23,916.00 May 2011
What I want to populate is: #1 "Last Month Billed" this will go to sheet1 under last month billed and it will pull the information from sheet2, under "Run Date".
#2 I also, want to put its latest status "billed in full", or "due in June" and this will be calulated from "the flight dates" and "last month billed".
Thank you guys!!!
