Thread: Cut & Paste visible cells on same row
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
  
Posts: 2,344
Default Cut & Paste visible cells on same row

--
Thanks,
Shane Devenshire


"YP" wrote:

whats your email?

"ShaneDevenshire" wrote:

Hi YP,

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

--
Thanks,
Shane Devenshire


"YP" wrote:

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,
Reply With QuoteReply With Quote