append rows with new data

[Roland53]

I'm not sure where to begin on this one...Office Pro 03'


I am taking a list of data and blending it with an Excel database. For each row in the list of new data I need to take that information and add it in the proper row and in the proper columns in the database. The each row in the database is keyed off of a "Tag #"

 

[Roland53]

Format

tried to fix the protocol of my last post

 

[Roland53]

Am working with it but still unsure n/t

...

 

[erik.van.geit]

Roland,

WELCOME to the Board.

We need an example of what you're trying to do.
use Colo's HTML Maker utility for displaying your Excel Worksheet on the board

kind regards,
Erik

 

[Roland53]

Thanks...I'll post one

Thanks!

 

[erik.van.geit]

Roland53,

(to avoid the &bnsp see main page Excel)

You're showing a vast example of a SITUATION
To be able to help we need a little example with
BEFORE
what you want to happen
AFTER

something like this

be sure I'll follow up,
Erik

Map1.xls
	A	B	C	D	E
1	source
2	tag#	rsd	other
3	1	1-1-05	a
4	2	1-1-05	b
5	3	1-1-05	c
6	4	1-1-05	d
7	5	1-1-05	e
8	put info of column C in columns sheet2
9
10	target
11	1	2	3	4	5
12	a	b	c	d	e
tag

kind regards,
ERik

 

[Roland53]

This is the target sheet...the last columns that are blank

Miken Scaffold Logtemp.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Tag#	RentStartDate	Built_Date	Built_By	Off_Rent_Date	TearDownDate	TearDown_By	Scaff_Type	Scaff_Tag#	Master_Tag#	Scaff_Ht	Scaff_Legs	Total_LgFt	Owner	Z_Foreman	Plant_Block	Location	WO#	M_NM	Charge#	Requested_By	Date Audited	Auditor	Error Found	Date Error Corrected	Date Employee Retrained
2	27684	01/31/05	01/14/05	B SOTO				5	27684	217684	65	1	65			OC100	HI RISE	92435602	M	6305	ROWELL
3	28004	01/31/05	01/05/05	N SANCHEZ				23	28004	218004	45	1	45			OC600	TLU DECK	92116700	M	5581	BEACH
4	98124	01/31/05	08/14/02	W HARDIN				5	98124	98124	65	1	65	DOW		OC400	UNDER ELEVATOR	76066250	M	8126	WILEY
5	98125	01/31/05	08/14/02	W HARDIN				5	98125	98125	65	1	65	DOW		OC400	UNDER ELEVATOR	76066250	M	8126	WILEY
Miken Scaffold Log

 

[Roland53]

more..

contain the cells the daily input data need to populate....like this...

 

[Roland53]

the daily input...

test.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	CREWLEADER	FORM #	TAG #	PLANT	BLOCK	BLD. DATE	AUDITOR	BADGE #	AUDIT DATE	Week Ending	Error 1	Error 2	Error 3	Date corr	Who	Date Retrained	Trainer	Confirmed by
2	M. Ordonez	113858	223053	A	800	2/3/2005	Lindley	6057	2/4/2005	2/10/2005
3	J. Cisneros	113883	223127	A		2/8/2005	Lindley	6057	2/9/2005	2/10/2005	8A	11B		2/9/2005	J. Cisneros	2/9/2005	Miller, J.	Green, B.
4	J. Cisneros	19495	223128	A		2/8/2005	Lindley	6057	2/9/2005	2/10/2005
Sheet1

 

[Roland53]

there is now audit info in the last columns

Miken Scaffold Logtemp.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Tag#	RentStartDate	Built_Date	Built_By	Off_Rent_Date	TearDownDate	TearDown_By	Scaff_Type	Scaff_Tag#	Master_Tag#	Scaff_Ht	Scaff_Legs	Total_LgFt	Owner	Z_Foreman	Plant_Block	Location	WO#	M_NM	Charge#	Requested_By	Date Audited	Auditor	Error Found	Date Error Corrected	Date Employee Retrained
2	27684	01/31/05	01/14/05	B SOTO				5	27684	217684	65	1	65			OC100	HI RISE	92435602	M	6305	ROWELL	12/5/2005	Bozarth
3	28004	01/31/05	01/05/05	N SANCHEZ				23	28004	218004	45	1	45			OC600	TLU DECK	92116700	M	5581	BEACH	12/5/2005	Bozarth	11c	12/5/2005	12/5/2005
Miken Scaffold Log