Is there an easier way to copy and paste without using macros or vba?

[Ultimate Selector]

Just curious if there is a simple and easy way to copy and paste one line of data from one workbook to another and have it retain it's values and conditional formatting? It simply needs to look exactly like where I copied it from the other workbook. I don't want to have to use vba or macros. Any ideas?

Thanks in advance!
U.S.

 

[Ultimate Selector]

Well I guess by all the replies this thread has recieved it must mean mean that there is no way to accopmlish this! LOL!

 

[Fazza]

Well I guess by all the replies this thread has recieved it must mean mean that there is no way to accopmlish this! LOL!

Maybe. Maybe not. Maybe the question wasn't well explained.

 

[Ultimate Selector]

Well I guess by all the replies this thread has recieved it must mean mean that there is no way to accopmlish this! LOL!

What more would like for me to explain to help you understand my dilemma?
All I want to do is to simply take one simple line of data among other lines of data from one workbook let's call it Book A.
Then I want to copy that one line of data to another work let's call it Book B.
Now when I do that and try to paste (after I copy it) that one line of data from A to B it does NOT retain the same values from Book A to Book B.
I'm wanting to put together a complete book (B) of all similar patterns from that one line of data from A when it happens. It can happen more than 10 times a day, every day.
So this way I have a condensed book (B) of all winning patterns from all the data from Book A.
That way I can see all the commonalities from the patterns.

I hope this clears it a bit more!

Thanks,
U.S.

 

[Ultimate Selector]

I am Bumping this simply because I still have not found an answer in all my research for this problem.

I hope there is someone here that can help me out on this issue!

Much Appreciated!
U.S.

 

[mbpress01]

Can’t you just manually copy, paste special values and duplicate the conditional formatting. You seem to want it automated without vba - sorry but excel is either manual or vba. If you don’t want to do it manually you have to use vba. Further vba seems well suited to what you want to do. If you show the group the workbook, the sheets and the data I am confident you will get something back worthwhile. If you are intimidated by vba, trust me your in good company. It’s doesnt take much time to learn the basics and will save you hours and hours of time in you work.

 

[Ultimate Selector]

Thanks MB for your response. I have tried to do it manually with paste special and all. However, it still does not paste the same data. I would then have to go and re input all the lines of data and I'm not going to be doing all that. I also am not all that great with VBA yet as I don't really need it for much of what I'm doing here.

Just thought there was a way to do it with some easier lazy way! LOL!

 

[My Aswer Is This]

When I copy one line of data from One workbook to another it retains all formatting.

So I do not understand why it does not work for you.

 

[Ultimate Selector]

When I copy one line of data from One workbook to another it retains all formatting.

So I do not understand why it does not work for you.

The formatting isn't the problem. It's the actual data in each of the cells. For some reason the data isn't being transferred. I don't know why.

 

[My Aswer Is This]

Give me a example.

If the row you copy says:

Frank is my name

And you copy the row and paste in other workbook what happens?

You must have some formulas in those cells.