Need help with vlookup macros and tallying

[spryng]

Good Morning,
so I'm self taught with excel and I'm still learning as I go but I was tasked with creating a specific invoice workbook and I am stuck with a couple issues.. first on my Invoice tab, when I choose between different invoice numbers it is not wiping the invoice clean to start a new invoice but leaving info from the other invoices in there.. how do I fix that? also, I am needing to create a tab that just calculates hours from each invoice/technician, one for each invoice and then an accumulative one for that technician showing total hours too.. first, am I allowed to attach it here for viewing? it's hard to explain if you all can't see it.. or if someone is really good with excel formulas etc can you PM me and help me out? Please let me know, thanks!

Edit: I have attached the file so you can see what I'm talking about. So any feedback, advice, etc is appreciated.

[FDibbins]

Hi, welcome to the forum

Thanks for the title change

Yes, we welcome attachments here (but we prefer that all discussion take place in the thread, that way all can participate)
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[spryng]

Thank you so much, I have attached the file.

[spryng]

Anyone? I was hoping to have this completed by the end of this week but I'm stuck.

[JohnTopley]

I find the "Invoice" tab confusing as you have (a) drop down list in column B and (b) a formula in column B. Selecting from drop down overwrites the formula.

You then have 2 other invoice-related tabs : "Invoices - Main" and "Invoice Details" so it is not clear to me how the data for an invoice is collated.

If the Invoice data in row 9 was derived by formulae then it is possible to overwrite the data when a new invoice number is entered BUT where do you enter and keep the "historical" data for all invoices?

[spryng]

Thank you John, maybe that is my problem, I'm making it too complicated. Invoices - Main is what pulls over to Invoice, Invoice details is supposed to be the historical data from the Invoice but it's not pulling the new ones over. Right now my main issue is getting those hours sold to pull to a new tab, track by invoice and total by technician number. Any advice on what to change?

[spryng]

John any ideas how I can fix that? I am so stuck and this project has to be finished by the end of this week.

[Pete_UK]

I'll take a look later on, but I'm just about to go out now for a few hours. Maybe someone else will chip in while I'm out.

Pete

[spryng]

Thanks Pete! I appreciate that. I'm getting to the desperate stage lol

[spryng]

Hey Pete, were you able to take a look?