move data w/o blank data to another sheet

R

reza

Hi all....

i want to move data from sheet1 to another sheet, maybe it will need
macro...hope you can help me. Example...in sheet1 i have:
Line Col A Col B Col C Col D
AA 10 5 4 1
BB 5 - - -
FF 13 3 2 2
KK 10 - - -

now in sheet2 i want to create resume from sheet1 automatically....
but i want if col B is empty or no data...it can't move to sheet2...
so and in sheet2
Line Col A Col B Col C Col D
AA 10 5 4 1
FF 13 3 2 2


thanks in advance

reza
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

move blank data 10
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Loop thru xx No. of sheets until the four strValue combo's are found 6
Transpose & reorg data from 2 WS to new WB 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
3 results possible on every day. add up the number of each on each day. 2

Top