Hi All,
I have quite a tough one here....I have a bit of a unique problem, for which I was wondering if someone could help me with a VBA code. I download data through a query from a rather antiquated financial package, see below.
My problem is with column G "comments", which as you will see from rows 5 & 9, whose contents belong at the end of the cell directly above it..
Could somebody help me with a code which will look at this data, where it finds a row with no data in columns a to e, it should then cut the contents of the relevant cell in column g and paste this at the end of the cell above and delete the now empty row, to produce the the spreadsheet as below:
[HTML removed by admin]
I have quite a tough one here....I have a bit of a unique problem, for which I was wondering if someone could help me with a VBA code. I download data through a query from a rather antiquated financial package, see below.
sample.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | TRANSACTIONS | ACCOUNT | CENTRE | TYPE | VALUE | PERIOD | COMMENTS | SUPPLIER NAME................. | SUPPLIER | ||
2 | INVOICE12345 | 4095 | SI16 | INVOICE | 225.4 | 200309 | W/C: 15/9/2003 (98 PLTS) | MONKEYS INC | MON001 | ||
3 | INVOICE12346 | 4095 | SI16 | INVOICE | 255.3 | 200309 | W/C: 8/9/2003 (111 PLTS) | MONKEYS INC | MON001 | ||
4 | INVOICE12347 | 4095 | SI16 | INVOICE | 303.6 | 200309 | SAT/STCK,W/C:25/8/2003 | MONKEYS INC | MON001 | ||
5 | (132 PLTS) | ||||||||||
6 | INVOICE12348 | 4095 | SI16 | INVOICE | 282.9 | 200309 | SAT/STCK,W/C:1/9/2003 (123 PLTS) | MONKEYS INC | MON001 | ||
7 | INVOICE12349 | 5450 | SUS1 | INVOICE | 6.19 | 200309 | RETURNS,PERIOD ENDING:15/8/2003 | MONKEYS INC | MON001 | ||
8 | INVOICE12350 | 5430 | TRA1 | CREDIT NOTE | -4.72 | 200309 | SAT/STCK,INV:21684,ZONE 'B' | MONKEYS INC | MON001 | ||
9 | CHARGED S/B ZONE 'A' | ||||||||||
10 | INVOICE12351 | 5430 | TRA1 | CREDIT NOTE | -4.72 | 200309 | SAT/STCK,INV:21570,ZONE 'B' CHARGED S/B ZONE 'A' | MONKEYS INC | MON001 | ||
11 | INVOICE12352 | 5430 | TRA1 | INVOICE | 9238.34 | 200309 | PALLETS,PERIOD ENDING:12/9/2003 | MONKEYS INC | MON001 | ||
12 | INVOICE12353 | 5430 | TRA1 | INVOICE | 103.85 | 200309 | XTRA'S,PERIOD ENDING:12/9/2003 | MONKEYS INC | MON001 | ||
13 | INVOICE12354 | 5430 | TRA1 | INVOICE | 70.75 | 200309 | OTHER,PERIOD ENDING:12/9/2003 | MONKEYS INC | MON001 | ||
14 | INVOICE12355 | 5430 | TRA1 | INVOICE | 391.13 | 200309 | POST,PERIOD ENDING:12/9/2003 | MONKEYS INC | MON001 | ||
Sheet1 |
My problem is with column G "comments", which as you will see from rows 5 & 9, whose contents belong at the end of the cell directly above it..
Could somebody help me with a code which will look at this data, where it finds a row with no data in columns a to e, it should then cut the contents of the relevant cell in column g and paste this at the end of the cell above and delete the now empty row, to produce the the spreadsheet as below:
[HTML removed by admin]