Everything done below highlighted row

[tropics123]

Hi! Any help on this would be greatly appreciated.

For example, row 89 is highlighted yellow but it can vary depending on the different data received daily. Everything above the highlighted yellow row are data and below the yellow highlighted row are all empty cells. Above the yellow highlighted row are many columns filled with data, and a lot of the columns have repeated headers. For example, there will be multiple columns with the header names "Type" and "Credit". I need some help with #2 & #3 below I greatly appreciate your help.

1) Above the yellow highlighted row: copy all data from columns A-L and paste it in the first empty cell in column A below the highlighted row. This one I can do the macro for.

2) If header name is "Type" (and may appear in multiple columns), put in word "Finance" in the same column directly below the yellow highlighted row and go all the down to match with the number of rows in column A (the word "Finance" can only start below the yellow highlighted row)

3) Copy all amounts in columns with header "Credit" and change the amounts to a positive number. The header "Credit" might be in multiple columns and need to find them all, and paste it directly in its respective columns below the yellow highlighted row.

 

[tropics123]

Hi Rick,

I tried your codes and it's not doing anything Sorry...I did leave out some pertinent information. I made some updates to the example table above. Row 1 contains the header. Everything above row 5 was already existing. The blue font was copied directly down below from above rows (no changes). The red font is what I'm hoping the VBA could do.

I wanted the VBA code to look in the header row for the word "Cont Type" (<- made change to that header since I just realized it's actually two words rather than one) and put the word "Finance" below the yellow highlighted row 5 and goes all the way down to match the number of rows in column A.

	columns A -->	L	M	N	O	P	Q	R
1	Name	Header	Cont Type	Credit	Cont Type	Credit	Cont Type	Credit
2	Bob	info	1	-800	4	-420	1	-486
3	Susan	info	2	-250	1	-510	5	-281
4	Mike	info	5	-310	1	-140	2	-334
5	FF (yellow highlight line starts here)
6	Bob	info	Finance	800	Finance	420	Finance	486
7	Susan	info	Finance	250	Finance	510	Finance	281
8	Mike	info	Finance	310	Finance	140	Finance	334
9	FF		Finance		Finance		Finance

<tbody>
</tbody>