Macro help with what if statement?

[Twiglet]

[TABLE="width: 602"]
<tbody>[TR]
[TD]I’m really new to recording macros, and managed to create loads of macros to get this far, but now I’m stumped.
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]I need to get rid of the <enter> that is in the same row as <esc><f9> and loop down until the end of the data 1500 rows.
[/TD]
[/TR]
[TR]
[TD]Then I need to have an account code of 30160, underneath the names, ie in column d where column a = <f4><up> again looping down to the end of the data
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]<enter> are in column G
[/TD]
[/TR]
[TR]
[TD]<esc><f9> is in column A

[TABLE="width: 471"]
<tbody>[TR]
[TD]coles[/TD]
[TD][/TD]
[TD][/TD]
[TD]SMITH[/TD]
[TD][/TD]
[TD][/TD]
[TD]<ENTER>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]<ENTER>[/TD]
[/TR]
[TR]
[TD]<F4><UP[/TD]
[TD="align: right"]04/04/2017[/TD]
[TD]APPLES[/TD]
[TD][/TD]
[TD="align: right"]1.00 [/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]140[/TD]
[/TR]
[TR]
[TD]<F4><UP[/TD]
[TD="align: right"]13/04/2017[/TD]
[TD]APPLES[/TD]
[TD][/TD]
[TD="align: right"]1.00 [/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]140[/TD]
[/TR]
[TR]
[TD]<F4><UP[/TD]
[TD="align: right"]18/04/2017[/TD]
[TD]PEARS[/TD]
[TD][/TD]
[TD="align: right"]1.00 [/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]140[/TD]
[/TR]
[TR]
[TD]<ESC><F9>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]<ENTER>[/TD]
[/TR]
[TR]
[TD]woolworths[/TD]
[TD][/TD]
[TD][/TD]
[TD]JONES[/TD]
[TD][/TD]
[TD][/TD]
[TD]<ENTER>[/TD]
[/TR]
[TR]
[TD]<F4><UP[/TD]
[TD="align: right"]04/04/2017[/TD]
[TD="colspan: 2"]BANANAS[/TD]
[TD="align: right"]1.00 [/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]140[/TD]
[/TR]
[TR]
[TD]<F4><UP[/TD]
[TD="align: right"]06/04/2017[/TD]
[TD]APPLES[/TD]
[TD][/TD]
[TD="align: right"]1.50 [/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]120[/TD]
[/TR]
[TR]
[TD]<ESC><F9>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]<ENTER>[/TD]
[/TR]
[TR]
[TD]aldi[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]CAMPBELL[/TD]
[TD][/TD]
[TD]<ENTER>[/TD]
[/TR]
[TR]
[TD]<F4><UP[/TD]
[TD="align: right"]18/04/2017[/TD]
[TD]APPLES[/TD]
[TD][/TD]
[TD="align: right"]1.50 [/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]140[/TD]
[/TR]
</tbody><colgroup><col><col><col span="5"></colgroup>[/TABLE]



[/TD]
[/TR]
</tbody>[/TABLE]

 

[hiker95]

Twiglet,

If this is what your raw data looks like?

Excel 2007
	A	B	C	D	E	F	G
1	coles			SMITH
2
3		4/4/2017	APPLES		1.00	4	140
4		13/04/2017	APPLES		1.00	4	140
5		18/04/2017	PEARS		1.00	4	140
6
7	woolworths			JONES
8		4/4/2017	BANANAS		1.00	4	140
9		6/4/2017	APPLES		1.50	4	120
10
11	aldi			CAMPBELL
12		18/04/2017	APPLES		1.50	4	140
13
Sheet1

Then, what should the results look like?

 

[hiker95]

Twiglet,

1. Are these the results you are looking for?

Excel 2007
	A	B	C	D	E	F	G
1	coles			SMITH
2
3		4/4/2017	APPLES	30160	1.00	4	140
4		13/04/2017	APPLES	30160	1.00	4	140
5		18/04/2017	PEARS	30160	1.00	4	140
6
7	woolworths			JONES
8		4/4/2017	BANANAS	30160	1.00	4	140
9		6/4/2017	APPLES	30160	1.50	4	120
10
11	aldi			CAMPBELL
12		18/04/2017	APPLES	30160	1.50	4	140
13
Sheet1

2. Or, are these the results you are looking for?

Excel 2007
	A	B	C	D	E	F	G
1	coles			SMITH
2				30160
3		4/4/2017	APPLES	30160	1.00	4	140
4		13/04/2017	APPLES	30160	1.00	4	140
5		18/04/2017	PEARS	30160	1.00	4	140
6
7	woolworths			JONES
8		4/4/2017	BANANAS	30160	1.00	4	140
9		6/4/2017	APPLES	30160	1.50	4	120
10
11	aldi			CAMPBELL
12		18/04/2017	APPLES	30160	1.50	4	140
13
Sheet1

3. What is the raw data worksheet name?