Need a code for : In a particular column (A) - If a cell is numeric then the next cell is text. Copy entire row with the numeric cell and copy and paste insert down.
example
If
A3= 1234
A4= Text
Then copy row A3 and paste insert
Needs to loop and find all instances in that column, end loop when no more instances
Can this be done?
Last edited by sambuka; 06-28-2012 at 10:49 AM.
bump no response
Hard to understand what you need?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
I have attached sample.
In Column A - If a cell in column a is numeric and the cell below is text then copy the entire row and insert and paste.
For example - Cell (A21) is numeric Cell(A22) is text. I need to have Row (A21) to be copied and Insert Copied shift cells down.
This needs to be looped to catch all instances. (Again in A46, A47)etc
(There will be an array of worksheets to run this macro through)
Let me know if more explanation is needed. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks