Evening all,
We're currently undertaking a tender process and are anticipating a number of bids to be received shortly. What I would like to develop is a macro that will extract all of the bids received for each task and place them into the relevant summarised table. Essentially the steps I would like the macro to undertake are as follows:
1. Browse and select the folder containing the files to be imported (or browse to the folder and select the files) into the summarised sheet.
2. Extract the supplier name from the 'supplier' tab (green cell) on each 'Tender Submission Document' workbook and copy it into the first empty cell in the relevant range (again highlighted green) on each of the 'Bids Task x' tabs (Bids Received Summary workbook).
3. Extract the rates bid for each task (blue cells - 'Tender Submission Document' workbook) and copy them to the relevant tab and cells (aligned to the correct supplier) in the 'Bids Received Summary' workbook (again highlighted blue).
I've attached an example of the bid submission and summary document that I'm working with.
I hope this makes sense? If you have any questions do not hesitate to contact me.
Regards,
Snook
Bookmarks