Hi, thank you for your effort. This kind of macro would help, I would just like to improve on the pasting part. I will try and build on your code. Right now I have to select target sheet and target range for pasting manually. I need to upgrade this so that macro will also select the target apropriate sheet and range. In order to do this I probably have to define all existing subject areas (ie ranges) and then gather parameters via input boxes or ad list on the form you created.
So it would go like this: 1. Select source range - manually 2. Define parameters: project, subproject and subject area - manually by inputing or selecting data from predefined list 3. Open target file - manually 4. Paste values with transpose to corresponding range, depending on the defined parameters. 5. Save and close I know its not as simple as I've just written, since there are many subject areas and consequently many if clauses.... If you or anyone wil try to help me with this further I appreciate it very much and odn't worry about the exact source and target ranges, I can modify them later. Just note as above: --------------------------------------------------------------------------------------------------------------- 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 --------------------------------------------------------------------------------------------------------------- thx and regards, seba On 11 avg., 17:10, "Rajan_Verma" <rajanverma1...@gmail.com> wrote: > See if it helps > After select the Range which need to be Copies Press Alt+F8 and Run the > Macro Show, > > > > > > > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > > On Behalf Of Seba > Sent: Wednesday, August 10, 2011 8:07 PM > 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 > > > > Book2.xlsm > 26 1KPrikažiPrenesi -- ---------------------------------------------------------------------------------- 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
