Here is what I would like to be able to do;
Using excel I want to be able to import certain data fields, from certain text files, inside a certain folder, into certain cells on an ongoing updated spreadsheet, adding rows as I go. There maybe anywhere from two to 100 text files in the folder at any time. Let’s say my folder is on the desktop of “C” drive and named, “Import This Data”. My excel spreadsheet is titled “Imported Data”.
Example of my spreadsheet;
A B C D E F G H I J K L
4 Part# LOT# Lat# Status Date Tested Another Date PR1-
SAM#1
PR1-SAM#2 PR1- SAM#3 PR2-SAM#1 PR2-SAM#2 PR2-SAM#3
5 999999X 88888888 L999999 04/12/2018 13724.365 14577.026 13405.151
6168.254 8098.348 6358.175
6


The text file name would be changing but have this in common at the end of the name, “_Summ”.
Here is an example of what the text file looks like when imported into excel;
A B C D E F G H I
1
Identity Line 1
YYYYYYYYYYY
2
Identity Line 2
XXXXXXXXXX
3
Production L/N:
8888888888
4
LAT Number:
L999999999
5
(PN):
999999X
6
Lot Description
xyz
7
Date Tested:
Thu Apr 12, 2018 08:00 AM
8
Operator ID#
7777
9
# Samples
B
10
Visual Insp Msg
11
Sample Number (S/N):
Test Type:
Test Temperature (C):
TTTTT
BWRRR
BWBU
SOR
Peak Pressure 1
Peak Pressure 2
12
1
B
X X X X X 13724.365 6168.254
13
2
B X X X X X 14577.026 8098.348
14
3
B X X X X X 13405.151 6358.175