Excel Script help!
Closed
rofcam
Posts
1
Registration date
Wednesday April 14, 2010
Status
Member
Last seen
April 14, 2010
-
Apr 14, 2010 at 09:11 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 14, 2010 at 10:13 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 14, 2010 at 10:13 PM
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
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
Related:
- Excel Script help!
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 14, 2010 at 10:13 PM
Apr 14, 2010 at 10:13 PM
Could you put sample file at some shared location like https://authentification.site and post back the link here.