• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    Macro to copy paste filtered table

    Answer to question 1. Works beautifully so far. The reason I ask for question 2 as I will be automating the entire process based on selections. So extra clicking becomes a error prone pain. Best, Francis
  2. N

    Macro to copy paste filtered table

    Hello, Question 1: I have a table which filtered using excel slicers. The table contains helper columns which aid in the filtering process but I do not want to copy and paste to a new sheet. My macro copies the entire table including the undesired helper columns. >>> use code - tags <<< Sub...
  3. N

    Macro to filter complex dataset based on multiple columns

    Posts for help on other sites https://www.excelforum.com/excel-programming-vba-macros/1300751-dynamically-filter-data-in-two-columns-to-a-different-sheet.html#post5251388 https://www.mrexcel.com/board/threads/macro-to-filter-complex-dataset-based-on-multiple-columns.1118906/page-2#post-5394753
  4. N

    Macro to filter complex dataset based on multiple columns

    Marc, So can give you an example of an advanced filter that achieves the same result as the macro I used. In the first column labelled "Sample". There are 4 separate Samples (i.e Sample1, Sample2, Sample3 and Sample 4) which need to filtered from eachother. I then need to select three...
  5. N

    Macro to filter complex dataset based on multiple columns

    Alan, Today, I have been able to edit a macro to copy and paste my filtered "raw data" into a "filtered data" sheet. At the moment, I click a button to execute the macro after I have filtered the data. I now need help on how to automatically run the macro when I finish filtering the data in...
  6. N

    Macro to filter complex dataset based on multiple columns

    Hi Alan, Thank you for the macro code. At the moment the macro doesn't allow me to select two names in Column 2. In the ideal world. I would manually filter the table via raw data table. by for example Selecting "Sample 1" in Column A and Selecting both 001, 002 in Column B and it would...
  7. N

    Macro to filter complex dataset based on multiple columns

    Alan, Yes Marc's suggestion works manually but I have hundreds of samples that needs to be completed and I need a automated solution to the problem. The filtered data in sheet 2 has to be fed in a excel spreadsheet for further calculations. Best, Francis
  8. N

    Macro to filter complex dataset based on multiple columns

    I first want to filter the data in Column A. Select either Sample1, Sample2, Sample3 or Sample4. After selecting the above Sample ID. I then need to filter the data in column B where I select either "001_Element 1_No IS, 002_Li_IS 1_IS_I" or "003_Element 2_No IS, 004_B_IS 2_IS_II" or...
  9. N

    Macro to filter complex dataset based on multiple columns

    Alan, No need for apologies. I may be missing something. How do I filter to Sample 2 in Column A and select different samples in Column B. Its not updating in sheet 2 when I filter on sheet 1. Best, Francis
  10. N

    Macro to filter complex dataset based on multiple columns

    Hi Marc, I have not found a way to use the advanced filter to filter on Column A and Column B and get it to go to sheet. Do you have an example of how to do this with my particular dataset. Best, Francis
  11. N

    Macro to filter complex dataset based on multiple columns

    Alan, It works for filtering Column A but I need to filter data in Column B as well and query doesnt do that in your example worksheet. For example. I need to filter Sample 1 with Type 001_Element 1_No IS 002_Li_IS 1_IS_I Anyway to tweak your query mcode to achieve this goal. Best...
  12. N

    Macro to filter complex dataset based on multiple columns

    Hello, I have a dataset in "Raw Data Sheet" that needs to be filtered on words (Sample 1, 2, 3, 4) in Column A + other key words in Column B. I then need that filtered data to automatically appear in "Filtered Data Sheet". I have manually filtered some of the data as an example but I need a...
  13. N

    Help with Gas Chromatography Data Processing

    Chihiro, I am hoping you might be of assistance again in my Gas Chromatography data processing needs. The company Agilent has upgraded the software and it now provides data in a different format. I would like to batch process the .csv text files in a folder by merging all the results together...
  14. N

    Help with Gas Chromatography Data Processing

    Strange, once i restarted excel. its works perfectly.
  15. N

    Help with Gas Chromatography Data Processing

    The 2nd code does a great job of organizing data and hiding the columns but it makes the header info split into separate columns. See effect below. [contents] count=2 Name= C:\MassHunter\GCMS\1\data\2019-08-15_1317_Sample Test\Blank 1.D 1= INT TIC: Blank 1.D\data.ms 2= PBM...
  16. N

    Help with Gas Chromatography Data Processing

    Chihiro, Sorry the confusion. The compounds colored are a calibration standard and we dont need calculate those results. The standards provide the signal/concentration response that is then used to calculate the results for the unknown compound concentrations in each separate file in the...
  17. N

    Help with Gas Chromatography Data Processing

    Chihiro, I had some errors at the start but I was able to do slight edits and troubleshoot the code. The only problem is that end of spreadsheet repeats line 274 on the row 275 with out being column to text separated. I need need to hide columns D-H, L-N and P because it contains redundant...
  18. N

    Help with Gas Chromatography Data Processing

    Correct, I believe this is the default format but could you use the [contents] in row 1 as start and Time= in row 7 as end of header justin case it adds any additional info into the header. Best, Francis
  19. N

    Help with Gas Chromatography Data Processing

    Hello Everyone, In Dec 2018, Chihiro helped me process data from a Gas Chromatography Mass Spectrometer instrument (https://chandoo.org/forum/threads/help-with-macro-to-organize-gas-chromatography-instrument-data.40450/post-242073) I was hoping someone could find the time to help me again as...
  20. N

    Rearrange Data from rows to columns

    Hello Everyone I need to rearrange a dataset from rows to columns in sheet 1 of attached excel spreadsheet. The data repeats every 13 rows. I made an example of what I am trying to achieve in sheet 2. Can anyone suggest a way to do this? Best, Francis
  21. N

    Rearrange & Convert X-ray Spectroscopy Data into a new ASCII format

    Hi I did reply about blue text in photo. "The sample file names can be very different. This format is fixed for a specific type of analysis but the file names for different project can vary alot." So the file names will not have the same structure all the time
  22. N

    Rearrange & Convert X-ray Spectroscopy Data into a new ASCII format

    Hi, The last file is transforming the single avg file into the MRS format. The next challenge is to batch process the avg files and save the processed file as .mrs file so it can read by the data processing software. Best, Francis
  23. N

    Rearrange & Convert X-ray Spectroscopy Data into a new ASCII format

    Hi The data is transformed perfectly (rows 91 to 343 in .avg file) Row 2 is the file path and sample name and changes for each sample test Row 2 is ;Dump of DataSpace 'C:\DataDump Data Extraction\ProjectFolder\01-01-2018_AABB_116208.VGD' I want to take the folder path in Row 2 of the avg file...
  24. N

    Rearrange & Convert X-ray Spectroscopy Data into a new ASCII format

    Vletm, Thank you for your help so far. So the key information in the .avg file is the Sample name, path and the raw data. I need a method to turn the .avg into the mrs format in a batch way. For the MRS file format, the "File path" should be placed in row 6 and 22 and the "File Name" in row 7...
  25. N

    Rearrange & Convert X-ray Spectroscopy Data into a new ASCII format

    The sample name is very important to keep connected with the new mrs file format. The folder path is important but not as critical.
Back
Top