copy and paste

Hi –Matt,
. You have explained your requirement quite well, and it sounds like a typical and “do- able thing”, but remember you know your project inside and out, but for someone seeing it for the first time it is going to be difficult to get a clear picture of what is going on..
.
. it is always preferred here if you try to produce Good before and after “ Pictures “ ( Not Images! ) as well as your explanations so I or anyone else can see exactly what you want..and importantly have some copyable test data to work with.

. The Before or Befores, should look just as it / they does before running of any macro.
.
. The After or Afters, should be hand filled by you so that it they / looks exactly as you want it to After running of any macro, based on the actual sample data in the Before / or Befores

. Make sure there is just enough data to demonstrate your need. Remember to desensitize the data if necessary, but use the typical Format type and choose your data carefully so that it can be used to test all possible scenarios.
...
To give these "Picture" - a few ways...( The second is what most people do )

. 1 ) use the Forum Tools in my signature to produce screen shots we can copy to a spreadsheet ( NO IMAGES ! )
. 2 ) Post Files
. 2 a) To Attach a sample workbook:
View Pic
http://www.excelforum.com/members/da...ch-a-file.html
http://tinyurl.com/oenwprw
. 2 b) Send over a file sharing site, such as this free thing
Box Net,
https://www.box.com/
http://tinyurl.com/7chr7u8
. Remember to select Share and give the link / links they give.
. 3 c) Only as a last resort, P.M **( Private Message ) . me and i will reply with my Email Addressee so you can send me a file
** To PM me, click on my name in the left hand margin when you are logged in, the rest should be obvious.

Alan

P.s. don’t “hope to receive a response too soon”, we are all volunteers here and do it for fun when we feel like it!! But if no one else picks up the thread I will try to do it for you sometime late tomorrow.

Originally Posted by mshuler1

Okay. Attached are each identically formatted examples of my two workbooks that I need help with....
.......
Just to make sure that everyone is understanding this request, let me try to explain it more clearly, considering the spreadsheets have been attached:......

Hi Matt,

.. I do think you have explained clearly. I am sure I would get it if I study a bit longer..But please remember you know your project inside and out. For someone seeing it for the first time you really must make it crystal clear, or the time we need to understand your requirement puts us off trying to help.
. I do not think you have quite understood or supplied what I was trying to ask for..

. Try again:
.
. Resend your Blank transmissions and highlight a cell ( in the A column I think ) where you enter data.
.
. I will assume the transaction Record File you sent is what I meant by the before
.
. Now send me again another transaction Record File where you type in manually and highlight the data that is copied to transaction record as a result of the highlighted selection in the blank transmission. That is what I meant by the After.
.
. And maybe just to be sure, ( using a different highlight color ) repeat the above for a selection in another sheet in blank transmission and show how that should appear in Transaction record.
. It should then be clear (even for me!! )

Alan

Hi Matt,
. I will be droping this one off my lists to answer as you have not replied.
. It would be helpful if you no longer want help here to mark the Thread as solved
Thanks
Alan