Vba question....?

tinkythomas

Active Member
Joined
Dec 13, 2006
Messages
432
Hello,

Can someone please suggest a vba procedure to transform this sheet.....
~858A.xls
ABCDEFGHIJKLM
1
2ALLOCATION CHARTREPORT NO
3
4EIACVVVSTART NO2913
5
6ANO0STOP NO2913999
7
8NOANONOMENCLATURESMRINTERVALMAINT LEVTASK DESCRIPTIONTASKCDFREQ
9
10
11P DATE
1229130XCSCHEDULED1ST LINETEST SENSORS1.08
13UNSCHEDULED1ST LINEPROCESS SYSTEM0
140PAOODSCHEDULED2ND LINEINSPECT FILTER2.16
15UNSCHEDULED2ND LINER+R NO30.1521
16SCHEDULED3/4TH LINERPR SYSTEM0.0166
17UNSCHEDULED3/4TH LINERPR TRANSDUCER0.0087
85.tmp
into this sheet...........
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

tinkythomas

Active Member
Joined
Dec 13, 2006
Messages
432
sorry the sheet should look like this after the procedure.......
CONCEPT.XLS
ABCDEFG
1EIACNOANOTYPCANTEXTSEQNARRATIVE
2VVV29130PB1SYSTEM:
3VVV29130PB2
4VVV29130PB3SCHEDULED 1ST LINE:
5VVV29130PB4TEST SENSORS
6VVV29130PB5
7VVV29130PB6UNSCHEDULED 1ST LINE
8VVV29130PB7PROCESS SYSTEM
9VVV29130PB8
10VVV29130PB9
11VVV29130PB10SCHEDULED 2ND LINE:
12VVV29130PB11INSPECT FILTER
13VVV29130PB12
14VVV29130PB13UNSCHEDULED 2ND LINE:
15VVV29130PB14R+R NO3
16VVV29130PB15
17VVV29130PB16
18VVV29130PB17SCHEDULED 3/4TH LINE:
19VVV29130PB18RPR SYSTEM
20VVV29130PB19
21VVV29130PB20UNSCHEDULED 3/4TH LINE:
22VVV29130PB21RPR TRANSDUCER
CONCEPT
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
I can see where some of the data comes from eg EIAC but what about TYP and CAN.

Also is this needed for multiple worksheets/books?
 

tinkythomas

Active Member
Joined
Dec 13, 2006
Messages
432
The typ and can columns are data that has to be added but this is always p and b respectively. Sorry for not making this clear in my post :oops:

No this isn't needed for multiple worksheets/workbooks, only the source sheet requires changing.
 

tinkythomas

Active Member
Joined
Dec 13, 2006
Messages
432
Hello again,

Sorry to bring this up again but this project won't go away and doing this procedure manually is very time consuming.

I just don't know how I can achieve my goal, I'm still learning vba.

If anybody can suggest some code I would be very grateful, in the meantime I will see what I can come up with!

Thank-you.
 

Forum statistics

Threads
1,181,365
Messages
5,929,548
Members
436,677
Latest member
CathalP1992

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
Top