Cut & Paste visible cells on same row

Y

YP

I have a table that is created by copying and pasting text from a pdf file.
The problem isthat when the text is pasted into excell it does not recoginzed
the missing data in somr rows so everthing is aligend in column A. I do a
filter to identify what rows need to be moved to the right 5 cells. I need
to cut only the visible cells with data in cells A-K and paste it in cells
F-P. Every time I try it I get an error that the function cannot be done.
Please help me, is there a macro I can create or a formula I can paste.

Thanks,
 
S

ShaneDevenshire

Hi YP,

Send me a sample of the data if you can, if not please diagram a sample of
your data here.
 
D

Don Guillett

Provide a layout of your problem here. Have you tried data>text to columns?
I could send you Shanes email but he may ?? not want it published here. Send
me your workbook to the address below or send me a personal request for his
email.
 

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

Cut & Paste Locked Cells 0
Search column for date format; cut and paste multiple cells to row above 1
I copied Visible Cells Only, but it pastes only the first cell 1
Filtering data 2
data spans multiple rows within each cell is collapsed when FILTER is used 0
VB Function for Copy & Paste 0
Copy/Paste Doesn't Carry Formats 2
Paste visible cells? 8

Top