L
lola_d
Hi All,
Firstly, thanks for all your helpful posts on here - I've used the
before, and now am adding my own. Apologies if this is covered anywher
already - I have searched but can't find it.
I have an excel file generated by an instrument that puts data fo
multiple samples in different blocks of columns, but under the sam
headings.
What I need to do is extract all of the columns in the "Data" sheet wit
a particular heading (Tail Intensity) and copy them into a ne
worksheet, in the same order that they were originally so I still kno
which sample is which. Even better would be if I could populate row
with the slide code (in A3, O3 etc). i.e. to label them, instead o
having to rely on the order. There could be in excess of 200 column
with Tail intensity as a header so this would save me a lot of time!
I'm new to VBA so this is over my head. If someone could tell me how I'
be very happy
+-------------------------------------------------------------------
|Filename: macro assistance screenshot.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=563
+-------------------------------------------------------------------
Firstly, thanks for all your helpful posts on here - I've used the
before, and now am adding my own. Apologies if this is covered anywher
already - I have searched but can't find it.
I have an excel file generated by an instrument that puts data fo
multiple samples in different blocks of columns, but under the sam
headings.
What I need to do is extract all of the columns in the "Data" sheet wit
a particular heading (Tail Intensity) and copy them into a ne
worksheet, in the same order that they were originally so I still kno
which sample is which. Even better would be if I could populate row
with the slide code (in A3, O3 etc). i.e. to label them, instead o
having to rely on the order. There could be in excess of 200 column
with Tail intensity as a header so this would save me a lot of time!
I'm new to VBA so this is over my head. If someone could tell me how I'
be very happy
+-------------------------------------------------------------------
|Filename: macro assistance screenshot.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=563
+-------------------------------------------------------------------