Compare and combine Date/Times between 2 sheets of data

[Sparktracer]

Hello experts,
This is what I want the finished work to look like (S3):

|-- A -- | -- B -- | -- C -- | --D --|-- E --|-- F --|--G --|-- -- H -- -- | -->
8/20/2010 21:18:03 -40 85.6 85 34
8/20/2010 21:19:03 -40 85.4 85 35
8/20/2010 21:20:03 -40 85 85 36 8/20/2010 21:20:43 Calculated Data 0.079 0.048 0.080 0.019 0.078 0.081
8/20/2010 21:21:03 -48.3 84.5 85 37
8/20/2010 21:22:03 -54.7 82.8 -40 xfer 0
8/20/2010 21:23:03 -39 85.5 -40 1
8/20/2010 21:24:03 -38.4 85.9 -40 2
8/20/2010 21:25:03 -39.2 85.5 -40 3
8/20/2010 21:26:03 -40.1 86.2 -40 4
8/20/2010 21:27:03 -40 85.3 -40 5
8/20/2010 21:28:03 -40.2 85.2 -40 6
8/20/2010 21:29:03 -40.2 84.8 -40 7
8/20/2010 21:30:03 -40.2 84.7 -40 8 8/20/2010 21:30:46 Calculated Data 0.051 0.064 0.056 (0.052) 0.023 0.082
8/20/2010 21:31:03 -40.1 84.9 -40 9
8/20/2010 21:32:03 -40.1 85.1 -40 10
8/20/2010 21:33:03 -40.1 85.2 -40 11
8/20/2010 21:34:03 -40.1 85.3 -40 12
8/20/2010 21:35:03 -40 85.5 -40 13
8/20/2010 21:36:03 -40.1 85.1 -40 14
8/20/2010 21:37:03 -40.1 84.9 -40 15
8/20/2010 21:38:03 -40.1 84.9 -40 16
8/20/2010 21:39:03 -40 85.3 -40 17
8/20/2010 21:40:03 -40.1 85.2 -40 18 8/20/2010 21:40:48 Calculated Data 0.055 0.038 0.051 0.028 0.044 0.047
8/20/2010 21:41:03 -40 84.9 -40 19
8/20/2010 21:42:03 -40.4 89 85 xfer 0

Here is the first set of data, (S1):

8/20/2010 21:18:03 -40 85.6 85
8/20/2010 21:19:03 -40 85.4 85
8/20/2010 21:20:03 -40 85 85
8/20/2010 21:21:03 -48.3 84.5 85
8/20/2010 21:22:03 -54.7 82.8 -40
8/20/2010 21:23:03 -39 85.5 -40
8/20/2010 21:24:03 -38.4 85.9 -40
8/20/2010 21:25:03 -39.2 85.5 -40
8/20/2010 21:26:03 -40.1 86.2 -40
8/20/2010 21:27:03 -40 85.3 -40
8/20/2010 21:28:03 -40.2 85.2 -40
8/20/2010 21:29:03 -40.2 84.8 -40
8/20/2010 21:30:03 -40.2 84.7 -40
8/20/2010 21:31:03 -40.1 84.9 -40
8/20/2010 21:32:03 -40.1 85.1 -40
8/20/2010 21:33:03 -40.1 85.2 -40
8/20/2010 21:34:03 -40.1 85.3 -40
8/20/2010 21:35:03 -40 85.5 -40
8/20/2010 21:36:03 -40.1 85.1 -40
8/20/2010 21:37:03 -40.1 84.9 -40
8/20/2010 21:38:03 -40.1 84.9 -40
8/20/2010 21:39:03 -40 85.3 -40
8/20/2010 21:40:03 -40.1 85.2 -40
8/20/2010 21:41:03 -40 84.9 -40
8/20/2010 21:42:03 -40.4 89 85

Here is the second set of data, (S2):

8/20/2010 21:20:43 Calculated Data 0.079 0.048 0.080 0.019 0.078 0.081
8/20/2010 21:30:46 Calculated Data 0.051 0.064 0.056 (0.052) 0.023 0.082
8/20/2010 21:40:48 Calculated Data 0.055 0.038 0.051 0.028 0.044 0.047
8/20/2010 21:50:48 Calculated Data 0.083 0.076 0.076 (0.012) 0.032 0.045
8/20/2010 22:00:49 Calculated Data 0.075 0.068 0.066 0.004 0.077 0.068
8/20/2010 22:10:50 Calculated Data (0.028) 0.014 0.068 (0.025) 0.042 0.049
8/20/2010 22:20:51 Calculated Data 0.056 0.041 0.053 0.020 0.040 0.049
8/20/2010 22:30:53 Calculated Data 0.110 0.065 0.044 0.068 0.129 0.086
8/20/2010 22:40:53 Calculated Data 0.047 0.005 0.088 0.026 0.089 0.063
8/20/2010 22:50:54 Calculated Data 0.122 0.013 0.043 0.090 (0.010) 0.038
8/20/2010 23:00:55 Calculated Data 0.034 0.043 0.045 0.021 0.033 0.049
8/20/2010 23:10:56 Calculated Data 0.062 (0.014) (0.001) (0.002) 0.073 0.035
8/20/2010 23:20:58 Calculated Data 0.048 0.135 0.090 0.011 0.027 0.040
8/20/2010 23:30:58 Calculated Data (0.064) 0.033 0.072 (0.045) (0.014) 0.010
8/20/2010 23:41:00 Calculated Data 0.055 0.044 0.055 0.031 0.051 0.050
8/20/2010 23:51:01 Calculated Data 0.037 0.115 0.447 (0.001) 0.004 0.075

Currently I am comparing the times in S1 column B with the times in S2 column A and then manually moving the data so the times matchup.

I have 3 months of data that I need to combine/compare.
A typical day of data:
S1 has 5 columns and up to 1445 rows.
S2 has 101 columns and up to 145 rows.

I have tried different formulas to move/copy the data from S2 into S1 but have had no luck.
Any assistance with this excel data compare and combine is greatly appreciated.

I am working with Windows XP and Office 2003.
We are allowed to use Macros and VB code. I have done very little with either.

Sparktracer

ps. I do not have HTMLMaker to create the formatted data. Sorry

 

[Sparktracer]

Excel Workbook
	A	B	C	D	E	F	G	H
1	Comment:	*	*	*	*	*	*	*
2	*	*	*	*	*	*	*	*
3	Date	Time	Cold Box	Hot Box	Load 1 SP	*	*	*
4	9/7/2010	23:55:19	-40.2	84.6	-40	*	6	*
5	9/7/2010	23:56:19	-40.2	84.7	-40	*	7	*
6	9/7/2010	23:57:19	-40.1	84.4	-40	*	8	*
7	9/7/2010	23:58:19	-40.1	84.7	-40	*	9	*
8	9/7/2010	23:59:19	-40.1	84.7	-40	*	10	*
9	9/8/2010	0:00:01	-40.1	85.3	-40	*	11	*
10	9/8/2010	0:01:01	-40.1	85.1	-40	*	12	*
11	9/8/2010	0:02:01	-40	85.4	-40	*	13	9/8/2010 0:02:43
12	9/8/2010	0:03:01	-40.1	85.4	-40	*	14	*
13	9/8/2010	0:04:01	-40.1	85.4	-40	*	15	*
14	9/8/2010	0:05:01	-40.1	85.3	-40	*	16	*
15	9/8/2010	0:06:01	-40	84.6	-40	*	17	*
16	9/8/2010	0:07:01	-40.1	84.4	-40	*	18	*
17	9/8/2010	0:08:01	-40	84.9	-40	*	19	*
18	9/8/2010	0:09:01	-40.6	89	85	xfer	0	*
19	9/8/2010	0:10:01	-40.1	87.7	85	*	1	*
20	9/8/2010	0:11:01	-39.9	87.5	85	*	2	*
21	9/8/2010	0:12:01	-39.9	86.2	85	*	3	9/8/2010 0:12:44
22	9/8/2010	0:13:01	-40	86	85	*	4	*
23	9/8/2010	0:14:01	-40	85.8	85	*	5	*
24	9/8/2010	0:15:01	-40	85.6	85	*	6	*
25	9/8/2010	0:16:01	-40	84.3	85	*	7	*
26	9/8/2010	0:17:01	-40.1	84.3	85	*	8	*
27	9/8/2010	0:18:01	-40	85	85	*	9	*
28	9/8/2010	0:19:01	-40	85.4	85	*	10	*
29	9/8/2010	0:20:01	-40	85.9	85	*	11	*
30	9/8/2010	0:21:01	-40	85.4	85	*	12	*
31	9/8/2010	0:22:01	-40	85.3	85	*	13	9/8/2010 0:22:45
32	9/8/2010	0:23:01	-40	85.2	85	*	14	*
33	9/8/2010	0:24:01	-40	84.9	85	*	15	*
34	9/8/2010	0:25:01	-40	84.5	85	*	16	*
35	9/8/2010	0:26:01	-40	84.5	85	*	17	*
36	9/8/2010	0:27:01	-40	84.6	85	*	18	*
37	9/8/2010	0:28:01	-40	84.7	85	*	19	*
38	9/8/2010	0:29:01	-43.4	85.8	-40	xfer	0	*
39	9/8/2010	0:30:01	-37.1	85.9	-40	*	1	*
40	9/8/2010	0:31:01	-38.9	84.3	-40	*	2	*
41	9/8/2010	0:32:01	-39.7	84.8	-40	*	3	9/8/2010 0:32:46
42	9/8/2010	0:33:01	-40.1	84.8	-40	*	4	*
43	9/8/2010	0:34:01	-40.2	84.4	-40	*	5	*
44	9/8/2010	0:35:01	-40.2	84.7	-40	*	6	*
45	9/8/2010	0:36:01	-40.2	84.7	-40	*	7	*
46	9/8/2010	0:37:01	-40.2	84.8	-40	*	8	*
47	9/8/2010	0:38:01	-40.1	84.9	-40	*	9	*
48	9/8/2010	0:39:01	-40.1	85.1	-40	*	10	*
49	9/8/2010	0:40:01	-40.1	84.7	-40	*	11	*
50	9/8/2010	0:41:01	-40.1	85.4	-40	*	12	*
TR14061 chamber 9-8-2010

This is the machine import with date/time matches and xfer position. Column H date/times are from the S2 data sheet/ These were manually copied to their correct locations.

 

[Sparktracer]

Excel Workbook
	A	B	C	D	E	F	G	H
1	9/8/2010 0:02:43	Calculated Data (mOhms)	(0.018)	0.038	0.064	(0.033)	0.000	(0.001)
2	9/8/2010 0:12:44	Calculated Data (mOhms)	0.064	0.032	0.149	0.026	(0.100)	0.105
3	9/8/2010 0:22:45	Calculated Data (mOhms)	0.045	0.032	0.088	0.041	0.204	0.074
4	9/8/2010 0:32:46	Calculated Data (mOhms)	(0.077)	0.029	0.043	0.373	0.069	0.128
5	9/8/2010 0:42:47	Calculated Data (mOhms)	(0.163)	0.085	0.016	0.148	0.039	0.001
6	9/8/2010 0:52:46	Calculated Data (mOhms)	0.121	0.126	0.083	0.037	0.212	(0.028)
7	9/8/2010 1:02:48	Calculated Data (mOhms)	0.050	0.112	0.082	(0.028)	0.058	0.059
8	9/8/2010 1:12:49	Calculated Data (mOhms)	(0.078)	(0.066)	0.050	0.029	(0.088)	0.003
9	9/8/2010 1:22:51	Calculated Data (mOhms)	(0.069)	0.046	0.053	0.096	0.011	(0.007)
10	9/8/2010 1:32:51	Calculated Data (mOhms)	0.038	0.100	0.137	(0.054)	0.216	0.080
11	9/8/2010 1:42:53	Calculated Data (mOhms)	0.058	0.037	0.037	0.023	(0.038)	0.073
12	9/8/2010 1:52:54	Calculated Data (mOhms)	0.336	(0.039)	0.052	0.086	(0.147)	0.119
13	9/8/2010 2:02:55	Calculated Data (mOhms)	0.016	0.032	0.136	(0.204)	0.043	0.072
14	9/8/2010 2:12:55	Calculated Data (mOhms)	0.089	(0.098)	0.139	0.080	0.173	0.044
15	9/8/2010 2:22:57	Calculated Data (mOhms)	0.047	0.044	0.075	0.032	0.102	0.036
16	9/8/2010 2:32:57	Calculated Data (mOhms)	(0.071)	0.012	(0.063)	0.085	(0.016)	0.031
17	9/8/2010 2:42:59	Calculated Data (mOhms)	(0.019)	0.081	0.083	0.090	0.070	0.075
18	9/8/2010 2:53:00	Calculated Data (mOhms)	0.093	0.108	0.083	(0.053)	0.095	0.007
19	9/8/2010 3:03:00	Calculated Data (mOhms)	0.077	0.082	0.029	0.043	0.056	0.069
20	9/8/2010 3:13:02	Calculated Data (mOhms)	0.487	0.097	(0.075)	0.210	(0.007)	0.014
21	9/8/2010 3:23:03	Calculated Data (mOhms)	(0.102)	(0.002)	0.017	0.076	0.062	0.073
22	9/8/2010 3:33:03	Calculated Data (mOhms)	0.065	0.050	0.080	0.013	(0.195)	0.060
23	9/8/2010 3:43:05	Calculated Data (mOhms)	0.039	0.056	0.040	0.039	0.119	0.069
24	9/8/2010 3:53:06	Calculated Data (mOhms)	0.959	0.174	0.035	(0.270)	(0.092)	0.139
25	9/8/2010 4:03:07	Calculated Data (mOhms)	0.102	0.158	0.029	(0.034)	(0.013)	(0.051)
26	9/8/2010 4:13:08	Calculated Data (mOhms)	0.037	0.005	0.102	0.079	0.082	0.037
27	9/8/2010 4:23:09	Calculated Data (mOhms)	0.026	0.022	0.096	0.020	0.142	0.075
28	9/8/2010 4:33:10	Calculated Data (mOhms)	(0.025)	0.072	0.076	0.117	0.048	0.050
29	9/8/2010 4:43:11	Calculated Data (mOhms)	0.177	(0.034)	0.115	0.013	(0.070)	(0.011)
30	9/8/2010 4:53:12	Calculated Data (mOhms)	(0.011)	0.075	0.055	0.056	0.055	0.060
31	9/8/2010 5:03:13	Calculated Data (mOhms)	0.079	(0.076)	0.067	0.055	(0.075)	0.065
32	9/8/2010 5:13:14	Calculated Data (mOhms)	0.052	0.071	0.070	0.066	0.093	0.063
33	9/8/2010 5:23:15	Calculated Data (mOhms)	0.107	0.012	0.058	(0.105)	0.022	0.020
34	9/8/2010 5:33:16	Calculated Data (mOhms)	(0.043)	0.072	(0.016)	(0.007)	0.053	(0.069)
35	9/8/2010 5:43:17	Calculated Data (mOhms)	0.064	0.093	0.050	0.001	0.088	0.071
36	9/8/2010 5:53:18	Calculated Data (mOhms)	0.064	0.105	0.054	0.046	0.077	0.073
37	9/8/2010 6:03:19	Calculated Data (mOhms)	0.069	0.020	(0.021)	(0.013)	0.088	0.162
38	9/8/2010 6:13:19	Calculated Data (mOhms)	0.069	(0.007)	0.051	0.074	0.068	0.077
39	9/8/2010 6:23:21	Calculated Data (mOhms)	0.029	0.013	0.099	0.020	0.046	0.077
40	9/8/2010 6:33:22	Calculated Data (mOhms)	0.069	0.054	0.077	0.020	0.019	0.058
41	9/8/2010 6:43:23	Calculated Data (mOhms)	0.192	0.087	(0.009)	(0.016)	(0.014)	0.037
42	9/8/2010 6:53:24	Calculated Data (mOhms)	0.035	0.065	0.039	0.045	0.007	(0.002)
43	9/8/2010 7:03:25	Calculated Data (mOhms)	0.231	0.097	0.097	0.021	0.045	0.056
44	9/8/2010 7:13:26	Calculated Data (mOhms)	0.050	0.019	0.066	(0.018)	(0.033)	0.053
45	9/8/2010 7:23:27	Calculated Data (mOhms)	0.014	0.080	(0.014)	0.084	(0.105)	0.078
46	9/8/2010 7:33:28	Calculated Data (mOhms)	0.035	0.040	0.099	(0.010)	(0.036)	0.063
47	9/8/2010 7:43:29	Calculated Data (mOhms)	0.055	0.080	0.155	0.095	0.216	0.082
48	9/8/2010 7:53:30	Calculated Data (mOhms)	0.045	0.112	0.070	0.034	0.125	0.042
49	9/8/2010 8:03:31	Calculated Data (mOhms)	0.132	0.038	(0.014)	(0.138)	0.025	0.094
50	9/8/2010 8:13:31	Calculated Data (mOhms)	0.054	0.063	(0.024)	0.060	(0.003)	0.028
TR14061 DAQ 9-8-2021

This is a small portion of the S2 data sheet. Highlights are manually done to denote hot or cold from S1 data.

 

[Sparktracer]

Here are copies of some of my final sheet. All this data was manually copied from S2 highlighted rows and then the calculations are done manually also. The first 4 rows are header data that is from a seperate sheet and will be used for all days of data.

Excel Workbook
	A	B	C	D	E	F	G	H
1			AM-34711-003-A
2			1SP
3		Connector/Header pin #	2	1	8	28	53	60
4		Initial DC data	0.056	0.053	0.070	0.028	0.046	0.063
5	9/8/2010 0:02:43	Calculated Data (mOhms)	(0.018)	0.038	0.064	(0.033)	0.000	(0.001)
6	9/8/2010 0:42:47	Calculated Data (mOhms)	(0.163)	0.085	0.016	0.148	0.039	0.001
7	9/8/2010 1:22:51	Calculated Data (mOhms)	(0.069)	0.046	0.053	0.096	0.011	(0.007)
8	9/8/2010 2:02:55	Calculated Data (mOhms)	0.016	0.032	0.136	(0.204)	0.043	0.072
9	9/8/2010 2:42:59	Calculated Data (mOhms)	(0.019)	0.081	0.083	0.090	0.070	0.075
10	9/8/2010 3:23:03	Calculated Data (mOhms)	(0.102)	(0.002)	0.017	0.076	0.062	0.073
11	9/8/2010 4:03:07	Calculated Data (mOhms)	0.102	0.158	0.029	(0.034)	(0.013)	(0.051)
12	9/8/2010 4:43:11	Calculated Data (mOhms)	0.177	(0.034)	0.115	0.013	(0.070)	(0.011)
13	9/8/2010 5:23:15	Calculated Data (mOhms)	0.107	0.012	0.058	(0.105)	0.022	0.020
14	9/8/2010 6:03:19	Calculated Data (mOhms)	0.069	0.020	(0.021)	(0.013)	0.088	0.162
15	9/8/2010 6:43:23	Calculated Data (mOhms)	0.192	0.087	(0.009)	(0.016)	(0.014)	0.037
16	9/8/2010 7:23:27	Calculated Data (mOhms)	0.014	0.080	(0.014)	0.084	(0.105)	0.078
17	9/8/2010 8:13:31	Calculated Data (mOhms)	0.054	0.063	(0.024)	0.060	(0.003)	0.028
18	9/8/2010 8:53:35	Calculated Data (mOhms)	(0.015)	0.049	0.005	0.004	(0.046)	0.061
19	9/8/2010 9:33:39	Calculated Data (mOhms)	0.090	0.107	0.113	0.225	0.120	(0.001)
20	9/8/2010 10:13:44	Calculated Data (mOhms)	0.017	0.070	0.075	(0.083)	0.002	0.029
21	9/8/2010 10:53:48	Calculated Data (mOhms)	0.053	0.069	0.093	(0.011)	0.056	0.169
22	9/8/2010 11:33:52	Calculated Data (mOhms)	(0.050)	0.039	0.024	(0.128)	0.049	(0.020)
23	9/8/2010 12:13:56	Calculated Data (mOhms)	0.106	0.035	0.103	0.090	0.077	0.019
24	9/8/2010 12:54:00	Calculated Data (mOhms)	0.159	0.022	0.020	0.092	(0.016)	0.053
25	9/8/2010 13:34:04	Calculated Data (mOhms)	0.020	(0.034)	0.035	(0.011)	0.068	(0.016)
26	9/8/2010 14:14:08	Calculated Data (mOhms)	0.042	(0.004)	0.069	0.014	0.038	0.017
27	9/8/2010 14:54:12	Calculated Data (mOhms)	0.126	0.067	(0.037)	(0.062)	0.088	0.012
28	9/8/2010 15:34:15	Calculated Data (mOhms)	0.147	0.064	(0.009)	0.128	(0.011)	(0.008)
29	9/8/2010 16:14:19	Calculated Data (mOhms)	(0.019)	(0.004)	0.065	0.016	0.091	0.113
30	9/8/2010 16:54:24	Calculated Data (mOhms)	0.035	0.075	(0.063)	0.139	(0.037)	(0.003)
31	9/8/2010 17:34:28	Calculated Data (mOhms)	0.045	(0.050)	0.027	(0.013)	0.045	(0.075)
32	9/8/2010 18:14:31	Calculated Data (mOhms)	0.020	0.050	0.090	0.093	0.206	0.055
33	9/8/2010 18:54:35	Calculated Data (mOhms)	0.038	0.132	0.059	0.071	0.157	0.020
34	9/8/2010 19:34:40	Calculated Data (mOhms)	(0.060)	0.040	0.008	0.098	0.030	0.061
35	9/8/2010 20:14:44	Calculated Data (mOhms)	(0.166)	0.058	0.088	0.022	0.071	0.291
36	9/8/2010 20:54:47	Calculated Data (mOhms)	(0.164)	0.077	0.005	0.101	(0.001)	0.104
37	9/8/2010 21:34:52	Calculated Data (mOhms)	0.173	0.091	0.027	(0.237)	0.011	0.071
38	9/8/2010 22:14:55	Calculated Data (mOhms)	0.118	(0.022)	0.078	(0.108)	0.042	0.193
39	9/8/2010 22:55:00	Calculated Data (mOhms)	0.009	0.064	0.063	0.115	(0.049)	0.026
40	9/8/2010 23:35:04	Calculated Data (mOhms)	0.088	0.017	0.104	0.141	0.051	0.127
41	COLD	Min	(0.166)	(0.050)	(0.063)	(0.237)	(0.105)	(0.075)
42		Max	0.192	0.158	0.136	0.225	0.206	0.291
43		Average	0.032	0.047	0.043	0.024	0.033	0.049
44
Cold and HOT Chamber Scans 9-8

Excel Workbook
	A	B	C	D	E	F	G	H
44
45	HOT	Average	0.059	0.046	0.067	0.034	0.057	0.060
46		Max	0.231	0.117	0.155	0.095	0.216	0.084
47		Min	0.023	(0.076)	0.000	(0.028)	(0.146)	0.005
48	9/8/2010 0:22:45	Calculated Data (mOhms)	0.045	0.032	0.088	0.041	0.204	0.074
49	9/8/2010 1:02:48	Calculated Data (mOhms)	0.050	0.112	0.082	(0.028)	0.058	0.059
50	9/8/2010 1:42:53	Calculated Data (mOhms)	0.058	0.037	0.037	0.023	(0.038)	0.073
51	9/8/2010 2:22:57	Calculated Data (mOhms)	0.047	0.044	0.075	0.032	0.102	0.036
52	9/8/2010 3:03:00	Calculated Data (mOhms)	0.077	0.082	0.029	0.043	0.056	0.069
53	9/8/2010 3:43:05	Calculated Data (mOhms)	0.039	0.056	0.040	0.039	0.119	0.069
54	9/8/2010 4:23:09	Calculated Data (mOhms)	0.026	0.022	0.096	0.020	0.142	0.075
55	9/8/2010 5:03:13	Calculated Data (mOhms)	0.079	(0.076)	0.067	0.055	(0.075)	0.065
56	9/8/2010 5:43:17	Calculated Data (mOhms)	0.064	0.093	0.050	0.001	0.088	0.071
57	9/8/2010 6:23:21	Calculated Data (mOhms)	0.029	0.013	0.099	0.020	0.046	0.077
58	9/8/2010 7:03:25	Calculated Data (mOhms)	0.231	0.097	0.097	0.021	0.045	0.056
59	9/8/2010 7:43:29	Calculated Data (mOhms)	0.055	0.080	0.155	0.095	0.216	0.082
60	9/8/2010 8:33:34	Calculated Data (mOhms)	0.063	0.029	0.079	0.069	0.121	0.063
61	9/8/2010 9:13:38	Calculated Data (mOhms)	0.056	0.043	0.083	0.060	0.107	0.058
62	9/8/2010 9:53:42	Calculated Data (mOhms)	0.059	(0.008)	0.087	0.020	0.028	0.071
63	9/8/2010 10:33:46	Calculated Data (mOhms)	0.052	0.080	0.062	0.055	0.109	0.064
64	9/8/2010 11:13:49	Calculated Data (mOhms)	0.054	0.057	0.036	(0.013)	0.085	0.072
65	9/8/2010 11:53:54	Calculated Data (mOhms)	0.045	0.101	0.074	0.039	(0.016)	0.055
66	9/8/2010 12:33:58	Calculated Data (mOhms)	0.047	0.064	0.085	0.018	0.003	0.054
67	9/8/2010 13:14:02	Calculated Data (mOhms)	0.060	0.034	0.042	0.031	(0.018)	0.064
68	9/8/2010 13:54:06	Calculated Data (mOhms)	0.049	0.067	0.107	(0.012)	0.058	0.064
69	9/8/2010 14:34:10	Calculated Data (mOhms)	0.062	0.095	0.045	0.080	0.163	0.054
70	9/8/2010 15:14:13	Calculated Data (mOhms)	0.047	0.028	0.044	0.045	(0.002)	0.012
71	9/8/2010 15:54:18	Calculated Data (mOhms)	0.073	0.076	0.000	0.014	0.078	0.069
72	9/8/2010 16:34:22	Calculated Data (mOhms)	0.064	0.059	0.052	0.076	(0.039)	0.074
73	9/8/2010 17:14:26	Calculated Data (mOhms)	0.041	0.043	0.095	0.004	0.105	0.084
74	9/8/2010 17:54:29	Calculated Data (mOhms)	0.086	0.019	0.068	0.083	0.115	0.075
75	9/8/2010 18:34:34	Calculated Data (mOhms)	0.047	(0.015)	0.042	0.047	0.028	0.033
76	9/8/2010 19:14:37	Calculated Data (mOhms)	0.054	0.087	0.082	(0.005)	0.167	0.064
77	9/8/2010 19:54:42	Calculated Data (mOhms)	0.060	0.058	0.070	(0.024)	0.120	0.074
78	9/8/2010 20:34:45	Calculated Data (mOhms)	0.039	(0.022)	0.087	0.042	(0.129)	0.041
79	9/8/2010 21:14:50	Calculated Data (mOhms)	0.023	(0.040)	0.020	0.068	(0.038)	0.025
80	9/8/2010 21:54:54	Calculated Data (mOhms)	0.062	(0.059)	0.086	(0.003)	0.091	0.063
81	9/8/2010 22:34:58	Calculated Data (mOhms)	0.033	0.117	0.027	0.081	(0.146)	0.005
82	9/8/2010 23:15:02	Calculated Data (mOhms)	0.096	0.109	0.022	0.030	0.036	0.040
83	9/8/2010 23:55:06	Calculated Data (mOhms)	0.059	0.052	0.093	0.047	0.058	0.072
Cold and HOT Chamber Scans 9-8

 

[Zack Barresse]

Okay, so as this can end up being a moderate to large project, let's do this in segments, or keep it somewhat modular. That way if you want to do additional items to your data, you can just code it and drop it on.

What I would like to know is if you want this from a userform, or rather more importantly, where do you want to fire this code from. It sounds like a prime candidate for an add-in.

 

[Sparktracer]

An add-in sounds wonderful to me.

 

[Zack Barresse]

So copy S1 worksheet A through H down to the last row, over to a newly created workbook. Then your S2 data, go through the data and where the date and time and where the rows find a match, copy data to that same row of S1's data. No other data from S2 should be copied? This will output to a new workbook?

 

[Sparktracer]

So copy S1 worksheet A through H down to the last row, over to a newly created workbook. Then your S2 data, go through the data and where the date and time and where the rows find a match, copy data to that same row of S1's data. No other data from S2 should be copied? This will output to a new workbook?

I import S1 data to S1, columns A - E.
I then import S2 data to S2, columns A - CW.
I then copy the header data into S3 from a master header file.
I then create columns F and G on S1, showing xfer and comditional formating to highlight rows 8 to 18 in a temp range, based off of xfer.
I then copy column A from S2 into column H of S1, aligning the times that match between H and B.
Then, based off of the 8 to 18 "window", I highlight the rows on S2 that are desired. The highlight color denotes a hot or cold reading.
I then copy just the desired cold readings to S3, create the minimum, maximum, and average values for all cold data.
I copy the min, max, avg rows from cold and past below the cold values.
I then copy the desired hot rows from S2 into S3.
I then adjust the the min, max, avg formulas for the hot data.

I hope this clears things up a bit.

 

[Zack Barresse]

I import S1 data to S1, columns A - E.
I then import S2 data to S2, columns A - CW.
I then copy the header data into S3 from a master header file.
I then create columns F and G on S1, showing xfer and comditional formating to highlight rows 8 to 18 in a temp range, based off of xfer.
I then copy column A from S2 into column H of S1, aligning the times that match between H and B.
Then, based off of the 8 to 18 "window", I highlight the rows on S2 that are desired. The highlight color denotes a hot or cold reading.
I then copy just the desired cold readings to S3, create the minimum, maximum, and average values for all cold data.
I copy the min, max, avg rows from cold and past below the cold values.
I then copy the desired hot rows from S2 into S3.
I then adjust the the min, max, avg formulas for the hot data.

I hope this clears things up a bit.

Lost me at the bold line. What do you mean "8 to 18"? Why those specific rows? Is it always rows 8 to 18 on S1? And when you copy S2 data which matches time, what columns from S2 are you grabbing? Cols A through...? Have you done this while recording a macro? That would give us a great start, and many, many details for us.

 

[Sparktracer]

Lost me at the bold line. What do you mean "8 to 18"? Why those specific rows? Is it always rows 8 to 18 on S1? And when you copy S2 data which matches time, what columns from S2 are you grabbing? Cols A through...? Have you done this while recording a macro? That would give us a great start, and many, many details for us.

Sorry about that. If you look at the S1 data, column G. The rows in column F that say xfer, column G is a zero. I then incriment column G by 1 until column F is equal to xfer again. I then have conditional formating to highlight in blue, the window of 8 to 18. This is the times from S2 that I want to use in S3.
I am grabbing just column A from S2 and manually comparing the date/times to S1 column B.

If it would be easier in VBA to take all columns from S2 into S1 and then sort the times, that is fine with me. We can then basically just delete all rows that have no data in S1 column H and then delete rows that are not in the 8 to 18 window.

 

[Zack Barresse]

Ok. I'm heading out for a bit, may not get back to this today. If you can record a macro of you doing this and post the macro, that would help also.

Also, how do you want to fire this off? Open a workbook, have a button there? On your command bar as a menu?