Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to move text cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to move text cell
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 Prescott http://www.apofficesolutions.co.uk Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to move text cell
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code to Automatically move text into above cells? | Excel Discussion (Misc queries) | |||
move to the cell on the right, my code not working pls help | Excel Programming | |||
VBA code to move contents from one cell to another | Excel Programming | |||
trouble with code to move text | Excel Programming | |||
VB code to move cursor 'one cell down? | Excel Programming |