Advertisement

Excel reports and working with macros...help?

Discussions about chromatography data systems, LIMS, controllers, computer issues and related topics.

2 posts Page 1 of 1
Hello,

How we've worked in the past using Masshunter, using 1 batch to report ~60 quantitive compound results, extracting the table data to Excel and then formatting relatively easily using simple macros to achieve a good looking report.

Now we've extended our number of compounds and we're using 3 standards, with congruent (is that the right word) compounds so we can use them as ICVs to each other.

The problem is that I'm getting 3 different excel files, and I need to make them into 1 (deleting duplicates), this is beyond my knowledge of excel macros.

Can anyone please help?
I've found a script that merges excel files, but I'd like to know of any tips you guys have for automating excel reports for a large quantity of analytes.
2 posts Page 1 of 1

Who is online

In total there are 2 users online :: 1 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 4374 on Fri Oct 03, 2025 12:41 am

Users browsing this forum: Google [Bot] and 1 guest

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry