VBA code to organise data from one sheet say sheet1 to sheet2

P

Power of God

New Member
Joined
Nov 6, 2017
Messages
1
Dear all, I want to organise the data below on a different worksheet so that data for different machines in the column MACHINE is kept separately, for example Barbed wire machine No 1.(Kakuru) fault data is kept seperately in a specific column say A and the FRQ data is kept seperately under B the TYPE data under C. I want to do this for a number of machines in order to analyse the data easily.
thanking you in advance:)

<tbody>
</tbody>

<tbody>
</tbody>
T.STAMPNAMEPHONEDEP.MACHINE TYPEFAULTOPFRQ
3/11/2017 14:26KIRABIRA JOSEPHO786974098MaintenanceBarbed Wire Machine No. 1 (Kakuru)ElecticalInverter errorYes2
3/11/2017 14:26KIRABIRA JOSEPHO786974098MaintenanceBarbed Wire Machine No. 1 (Kakuru)ElecticalInverter errorYes2
3/11/2017 14:28JONATHAN SEBANAKITTA03124647484Administration/HrBarbed Wire Machine No. 2 (Nyangoma)ElecticalMachine overheatingYes1
7/11/2017 10:28KIZITO WINAND0772456654ProductionBarbed Wire Machine No. 3 (Masiko)ElecticalAuxiliary Equipment failureYes2
7/11/2017 10:28KATO WINAND07745645467ProductionBarbed Wire Machine No. 4 (Kahoza)ElecticalAuxiliary Equipment failureYes2
7/11/2017 10:28KATO WINAND07745645467ProductionBarbed Wire Machine No. 5 (Nyamwiza)ElecticalAuxiliary Equipment failureYes2
7/11/2017 10:28KATO WINAND07745645467ProductionCooling TowerElecticalAuxiliary Equipment failureYes2
7/11/2017 10:29KATO WINAND07745645467ProductionExpanded Metal Machine(Babirye)ElecticalAuxiliary Equipment failureYes2
7/11/2017 10:29KATO WINAND07745645467ProductionBarbed Wire Machine No. 4 (Kahoza)ElecticalBurnt electrical gadgetYes2
7/11/2017 10:29KATO WINAND07745645467ProductionCorrugated Roll Forming Machine 1ElecticalBurnt electrical gadgetYes2
7/11/2017 10:30KATO WINAND07745645467ProductionBarbed Wire Machine No. 5 (Nyamwiza)ElecticalBurnt electrical gadgetYes2

<tbody>
</tbody>
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
You must log in or register to reply here.

Similar threads

M
  • Question
Auto-populate data from multiple sheets into one master sheet- Help
Replies
1
Views
124
alansidman
A
B
  • Solved
Build a duplicate data transfer button from a table in sheet one to a table designed in sheet two and specify each person in a row
Replies
6
Views
422
mumps
mumps
S
  • Question
Vba code to pull content from one sheet to another
Replies
1
Views
287
OaklandJim
O
C
  • Question
Transposing Data from two columns with a common data identifier into another column one row at a time
Replies
4
Views
645
Fluff
Fluff
RAJESH1960
  • Solved
VBA code to post data from one sheet to other but in different columns
Replies
8
Views
288
RAJESH1960
RAJESH1960

Forum statistics

Threads
1,215,274
Messages
6,123,991
Members
449,137
Latest member
abdahsankhan

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top