Is there a formula for copying sheet to sheet

**michelleob** · 05-19-2009, 05:58 AM

Hi,

at the moment in work we log all our orders on an excel sheet so litterally its like,
job no, customer, whats ordered, qty, price, who we ordered it from, order number, whats ordered, price to us.
i need to make a new sheet (job tracking sheet) that will contain the jobs that are still live so i can fill in a date on them as too when they are due in so i can track these jobs.

the new sheet will need job no, customer, whats ordered, qty, who we ordered it from, order number, date due in.
i am looking for a formula that will collect details from 4 different sheet of all the live jobs and put onto a seperate sheet.

however i dont know if its possible but, ideally i would like it so that when i update the live job on the main sheet as complete it would delete or hide off the job tracking sheet.

can anyone advise if this is possible and if so how to do it?

thanks!

**somesoldiers** · 05-19-2009, 07:50 AM

Hi Michelle

Why don't you attach your sheet and someone can take a look? would suggest removing/ replacing any sensitive data (client info etc) before you attach and showing the raw data as well as what you would like the data to look like when your finished

Noel

**michelleob** · 05-19-2009, 09:08 AM

Hi Noel,

thanks for that suggestion! would make it alot easier alright.. i have attached it now.

in the tab called sales sheet one, i have it laid out exactly like it is in mine at the moment. however the way customer 6 and 7 have an invoice number and an invoice date means that that job is complete and is invoiced therefore i need this to not appear anymore on the live jobs tab. i know i can manually just update both sheets but it is taking a lot of time to do this.

also is there anyway that if i put in some formula that if i put in say details into a new line, to enter a new sales job on sales sheet 1 tab that it will automatically pick up on the live job sheet?

i have used excel for a long time but i'm not very good at making sense of formula's i know what i want too do but not sure how to make it happen! lol..

thanks to anyone who can help me on this..

Michelle...

**somesoldiers** · 05-20-2009, 10:01 AM

Hi Michelle

i see what you need, leave it with me, might be the weekend before I can get back to you though, that's if no one else has answered in the meantime. Is that ok?