Hello,
ISelect specific column.xlsx
There are three sheets in the attached workbook.
I have specified the column numbers in "Requirement", based on the column numbers I want macro to select specified columns from "Data" tab and pasted on the "Outcome" tab.
An example workbook is attached here. Please let me know if this can be Programmed.
Regards,
Sandeep
You dont need VBA for this, this formula, copied down and across will give you what you want....
=IF(INDEX(Data!$A:$J,ROW(),INDIRECT("Requirement!a"&COLUMN()+1))=0,"",INDEX(Data!$A:$J,ROW(),INDIRECT("Requirement!a"&COLUMN()+1)))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello sandiptemkar
Since you did ask this question in the VBA forum, I have provided you with a VBA solution.
The attached workbook has a button the user can click after the column numbers have been entered. This will copy the headers from the Data sheet. The first row of the Outcome sheet is cleared and the new headers copied. All ranges are dynamic.
Here is the macro code that has been added to the workbook. It is annotated to make the code easier to understand.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Both,
Dear Ross,
The above code did not work for the text.
I tried many times but could not do it for my report.
Report is attached herewith please see if this can be fixed.
Sandeep
Excel Champs and Moderators,
Please help me on the above issue; I am just one step behind from getting this fixed.
Regards,
Sandeep
Can anyone help please?
Try the attached.
Thanks it worked very well!
But still need one update if you can do so.
While pasting the data I need macro to skip column number 4,5 and 8. No data to be pasted and these columns should be left blank.
Try the attached.
Thanks Much!
But the above code add the additional columns which I dont want since column 4,5 and 8 contains formulas and should remain untouched!
I know its asking too much but I am just one step behind getting this fixed.
I really appreciate all your help!
Regards,
Sandeep
If you have a formula, I have to use cell refrence and this has cost-speed
Hi,
As of now I have given the demo sheet however in actual "Outcome" tab there would be formulas are present on column 4,5 and 8 and hence I need macro to exclude them and past the data in appropiate columns.
Is this possible?
If not then I would add code for adding the formulas but is too much for me because the formulaes are really very big.
Any suggestions or ideas?
Please let me know.
Regards,
Sandeep
Sandeep,
Did you try the attach?
Last edited by AB33; 01-08-2014 at 08:06 AM.
Superb!
It worked; issue resolved! Amazing!!!
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks