Sample for Macro
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
|
 
Still loading...
ABCDEFGHIJKLMNOP
1
This is what I have
2
DateSale AmountCustomer NameNumberStreet Street TypeSuburb SuburbStatePostcode
3
2/26/10$47.27John Anderson20JohnROAD
4
GINGINQLD4671
5
6
Product 1 Total:$47.27
7
8
2/26/10-$10.91Bill Blogs18BillROAD
9
LAGOONPOCKETQLD4570
10
2/26/10$0.00Bill Blogs18BillROAD
11
LAGOONPOCKETQLD4570
12
2/26/10$0.00Bill Blogs18BillROAD
13
LAGOONPOCKETQLD4570
14
15
Product 2 Total:-$10.91
16
17
2/4/10$0.00The ShopPOBOX22336
18
GYMPIEQLD4570
19
2/26/10$16.36Jimmy John 680DELANROAD
20
GINGINQLD4671
21
2/26/10$8.19Jimmy John 680DELANROAD
22
GINGINQLD4671
23
24
Product 3 Total$24.55
25
26
27
This is what I need
28
29
DateSale AmountCustomer NameNumberStreet Street Street TypeSuburb SuburbStatePostcode
30
2/26/10$47.27John Anderson20JohnROADGINGINQLD4671NOTE: I have two street
and suburb columns for names
which are madee up of two words.
31
32
33
Product 1 Total:$47.27
34
35
2/26/10-$10.91Bill Blogs18BillROADLAGOONPOCKETQLD4570
36
37
2/26/10$0.00Bill Blogs18BillROADLAGOONPOCKETQLD4570
38
39
2/26/10$0.00Bill Blogs18BillROADLAGOONPOCKETQLD4570
40
41
42
Product 2 Total:-$10.91
43
44
2/4/10$0.00The ShopPOBOX22336GYMPIEQLD4570
45
46
2/26/10$16.36Jimmy John 680DELANROADGINGINQLD4671
47
48
2/26/10$8.19Jimmy John 680DELANROADGINGINQLD4671
49
50
51
Product 3 Total:$24.55
Loading...
 
 
 
Sheet1
Sheet2
Sheet3