Excel Script help!

[Closed]
Report
Posts
1
Registration date
Wednesday April 14, 2010
Status
Member
Last seen
April 14, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, I have a question about creating a (basic?) script that will pull some information out of a rather large excel file for me to eliminate a lot of tedious copying and pasting..

Pretty much what i am looking for is a script to pull out a row of information from a triplicated row what i have is n number of samples repeated 3 times but i just want to pull one of the data sets (rows) from each sample and put them onto a new spreadsheet thats a little more condensed.

ideally the script would only copy 1 of the three triplicates, and also only columns: B,C,D,F,M,N


I actually have a second part of the question but hopefully we can do this first :D I have been trying to record a macro and find a template but my lack of experience is kind of preventing me from doing so efficiently heh...thanks in advance

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you put sample file at some shared location like https://authentification.site and post back the link here.