I have a worksheet containing amongst other lines that are imported which I want cleared using VBA
----------
==========
I have attached a sample file. It would be appreciated if you would assist
Howard
----------
==========
I have attached a sample file. It would be appreciated if you would assist
Howard
Lines.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | ||||||||
3 | TOTALNETSALES | |||||||
4 | TOTALCOSTOFSALES | |||||||
5 | TOTALOVERALLOWANCE | |||||||
6 | ---------- | ---------- | ---------- | ---------- | ||||
7 | TOTALFRONTENDG/PROFIT | |||||||
8 | TOTALBACKENDG/PROFIT | |||||||
9 | TOTALG/PROFITADJUSTMENT | |||||||
10 | ---------- | ---------- | ---------- | ---------- | ||||
11 | TOTALADJ'DGROSSPROFIT | |||||||
12 | EXPENSES-VARIABLES | |||||||
13 | EXPENSES-PERSONNEL | |||||||
14 | EXPENSES-SEMI/FIXED | |||||||
15 | EXPENSES-TOTAL | |||||||
16 | ---------- | ---------- | ---------- | ---------- | ||||
17 | TOTALNET(PROFIT)/LOSS | |||||||
18 | ========== | ========== | ========== | ========== | ||||
19 | ||||||||
20 | ||||||||
21 | ||||||||
22 | ||||||||
23 | ||||||||
Sheet1 |