DATA formulas

Hello everyone, My apologies for being a bit of a dummy. Perhaps if I hang about I might learn more.

I am currently working with a spreadsheet actually multiple which I am sure could be consolidated with a bit of know how.

The spreadsheet is a maintenance log of activity that happens on various boats.

It looks a bit like;

Vessel name - Date - Action - Person - Charge

Then as this spreadsheet has all vessels and the company wants each vessel to have its own the same data is re typed into a new spreadsheet that looks the same just excludes all other vessel info.

From their yet another spreadsheet is prepared that creates the invoice - Way too much typing and re typing

I am sure that in the past I have been able to have a spreadsheet whereby I enter all data into sheet one and then I use a formula whereby sheet 2,3,4,5 can be formulated to collect the relevant data from sheet 1...... if that makes any sense at all???

Try to upload your sample workbook and explain you expected results, its the to attrack the solver see your problem, and hope find the solutions. To attach the file, click "Go Advanced" button and then find Paperclip button to attach your file

thanks

have u used vlookup

Pl update a sample file with expected results shown.