Programme to automatically populate XL Spread Sheet [Closed]

Report
Posts
3
Registration date
Tuesday June 9, 2015
Status
Member
Last seen
June 11, 2015
-
Hi All,

Im doing audit for diving equipment.

All data will be compiled in 1 excel file with several sheets.

1 - Record of Inspections - NC
2 - Mobilisation or Readiness - NC
3 - Record of Inspection-NC Certs.
4 - Record of Inspection - Obs.

5 - General Safety
6 - Dive Control
7 - Twin Lock Chamber
8 - Divers LARS (LARS 06)
9 - Divers LARS (LARS 13)
10 - Diving Basket 06
11 - Diving Basket 13
12 - Diver's Umbilicals
13 - Diver's Personal Equipment
14 - Compressors
15 - HP Air and Gas Storage



As I carry out the audit, I only populate (fill up) the 3 columns from sheet 5-15: "C/NC/OS", "Remarks" and "Cert Issued".

At the end of the 2nd day (normally the audit lasts 2 days), I have to provided a summary of items that have been audited as: NC and OS for each of the section audited but further placed under various Categories (sheet 1 - 4) ; namely:

Record of Inspections- The "C/NC/OS" column will be filled up with notation "NC" but has the "Cert. Issued" column empty)


Mobilisation or Readiness - The "C/NC/OS" column will be filled up with notation "NC" AND has the word "mobilisation" mentioned in the "Remarks" column.


Record of Inspections - The "C/NC/OS" column will be filled up with notation "NC" and has a "Cert Issued" Column filled.


Record of Inspections - The "C/NC/OS" column has been filled as "OS"


My requirement:

As I populate the 3 Columns for the various spread sheets (Sections 5-15), I need the data to appear automatically under their respective Sections in sheet 1 - 4.

Here example of sheet 1 - Record of Inspections - NC


and sheet 2 - Mobilisation or Readiness - NC


that I have done manual copy paste.

my email deleted by moderator

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!