I apologize for insufficient info. I am starting from scratch, but I don't see the option for file upload (where can I upload it?) so I'll try and explain in more detail.
My source workbook contains info on several subprojects. From here I need 3 items to be copied: - project number (always located in A2) - subproject number (each subproject is offset 1 line downwards: A5 = subproject 1, A6 = subproj. 2, etc.) - details for each subproject (represented as values in range: from B5 to H5) these items need to be copied and pasted with transpose in the target range. However there are 2 tricks to it: There are different target ranges pertaining to different subject areas. If a project belongs to a subject area LEGAL it should be pasted to that subject area target range. The other trick is to look for the first empty column in the target range so that existing values are not overwritten. Example for target range LEGAL: columns from A56:66 to G56:66 the problem for me is to get the excel to prompt me to select the target workbook and gather the parameters for pasting. Thx a lot, seba On 10 avg., 20:53, "dguillett1" <dguille...@gmail.com> wrote: > Post a file with a more complete explanation > > > > -----Original Message----- > From: Seba > Sent: Wednesday, August 10, 2011 9:36 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ copy selected range to target with params > > hi, > > I need help with writing a macro which would copy selected range and > prompt me for target workbook, sheet and range. It would need to copy > only values and transpose them. > > any help is greatly appreciated. > > Regards, > seba > > -- > --------------------------------------------------------------------------- > ------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
