I am really struggling to get Excel to work in the way I want it to.

We currently use a Microsoft Excel spreadsheet to produce quotations.

The workbook has several tabs which each comprise of different work elements. Each tab has a long list of codes in one column with prices and description in the adjacent row.

The final tab of this document is a quotation page specific to each job.

At present we have to look the code up on each tab and copy the row to the quote page. When there are lots of elements this takes a long time.

I want to be able to type the unique code in on the last tab and the associated data to automatically appear in the adjacent row.

This will greatly speed up the quotation process.

Is this something that can be done with macros?

Any assistance would be welcome.:confused

Thanks,
Mike