On Jun 14, 9:35*pm, "Crowbar via OfficeKB.com" <u15117@uwe wrote:
Hi There,

I don't quite know what you mean. Could you send me a spreadsheet with
example data and I will write the code in it for you and you can see what ive
done



Len wrote:
Hi,

Is there anywhere to move existing text from cell B5 & C5 under Row 5
to a blank row immediately below the existing Row 5, say Row 11 is a
blank row immediately below Row 5 and the result will show the
existing text moved from cell B5 & C5 to cell B11 & C11 and this
process continues until it reaches the furnishing row ?

Please help to set a macro or VB code to perform the above process,
thanks

Regards
Len

--
Anthony Prescotthttp://www.apofficesolutions.co.uk

Message posted viahttp://www.officekb.com

Hi Anthony,

Below is the extracted data to illustrate the above scenario : -

Col B C
D E F
4 Date Trans. No Reference No Description
Amount
5 61600.022 COC-04-001 & 04-002
6 19/03/2008 APD8-01024 00952001 DA003 1,258.00
7 21/03/2008 APD8-00990 9681 WF001
500.00
8 25/03/2008 APD8-01354 EKL-121 EX002 47.93
9 10/04/2008 APD8-01218 3127 TYH001
720.00
10 23/04/2008 GLP8-01411 0804/4f-2 LT002 658.70
11
3,184.63
12 61620 COC-05-001 Shobar
13 28/02/2008 GLP8-00682 036759(P) TB001 110.00
14 110.00
15 61637 COC-05-015 Brunei
16 01/01/2008 APD8-00627 50043 FU002 9,366.65
17 09/01/2008 APD8-00121 6741
EF002 952.00
18 09/01/2008 APD8-00214 9610
VI003 120.00
19 14/01/2008 APD8-00333 10499 OT002 28.00
20 14/01/2008 APD8-00334 10494 OT002 3,526.00
21 13,992.65

1st process to move cell B5 & C5 ( ie 61600.022 and COC-04-001 &
04-002 ) to cell B11 & C11
2nd process to move cell B12 & C12 ( ie 61620 and COC-05-001 Shobar )
to cell B14 & C14
3rd process to move cell 15 & C15 ( ie 61637 and COC-05-015 Brunei )
to cell B21 & C21

Thanks for your help

Regards
Len