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,

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,

What is the email address to send you the data

YP

"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,

Hi YP,

First, Excel allows you to copy from non-contiguous cells but it does not
allow you to paste in non-contiguous cells.

One simple solution is to sort your data on Column A Descending. Then do
your copy and paste.


--
Cheers,
Shane Devenshire


"YP" wrote:

What is the email address to send you the data

YP

"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,

If I sort the data I will loose the relation between the rows I want ot move
and the rows they are connected to. The records I need to move go with the
record listed directly before it, these lines are additional transactions to
the records.

"ShaneDevenshire" wrote:

Hi YP,

First, Excel allows you to copy from non-contiguous cells but it does not
allow you to paste in non-contiguous cells.

One simple solution is to sort your data on Column A Descending. Then do
your copy and paste.


--
Cheers,
Shane Devenshire


"YP" wrote:

What is the email address to send you the data

YP

"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,

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,

--
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,

Provide a layout of your problem here. Have you tried datatext 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.

--
Don Guillett
SalesAid Software

"YP" wrote in message
...
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,

Hi YVonne,

Well, let's see if this one gets through,

First, Excel allows you to copy a non-contiguous selection but not to paste
to a non-contiguous selection. That is the reason for your error message.

The easiest solution is to sort the data on column A in descending order
first, then you do not need to use the filter and copy and paste, or cut and
paste work fine.
--
Cheers,
Shane Devenshire


"Don Guillett" wrote:

Provide a layout of your problem here. Have you tried datatext 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.

--
Don Guillett
SalesAid Software

"YP" wrote in message
...
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,

Copy of email response:

In that case insert a new column A. In cell A2 type 1 in A3 2. Highlight
A2:A3 and drag the fill handle to the bottom of your data. Sort on column B,
do the copy and paste. Resort on Column A. Remove Column A.

Cheers,
Shane