+ Reply to Thread
Results 1 to 17 of 17

Move coulumns data of a sheet to diff other columns of other sheet in same workbook

  1. #1
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    694

    Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Req A VBA CODE: the column A B C D OF THIS SHEET "RE ARRANGE" TILL THEY HAVE THE DATA SHOULD MOVE TO ROW 2 OF COLUMNS A,E,D,F OF THE SHEET NAMED AS "FINAL SHEET" CORRESPONDINGLY

    ALSO ATTACHING A DUMMY WORKBOOK FOR SAMPLE
    Attached Files Attached Files

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Hello ROHAN999,

    You could do that with formulas, as used on the "RE ARRANGE" Sheet.

    Hope that helps.

    Also see the "Please consider" note at the bottom of this post.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    694

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    I knw...
    Before you tell..let me tell you that in my sheet "re arrange" i have a vba which delets many unwanted rows

    so when i use formulas..there #ref will come

    if i use-indirect....that also can't be drag for entire column,another thing in my final sheet i want data upto the data is there in columns a b c d of "re arrange" sheet

    that is why i want a vba for this purpose..so that after finalization of sheet 're arrange" data can be moved to columns of sheet "final sheet" as desired

  4. #4
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    694

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Common friends and experts,i have always got lot of support and help from this forum

    kindly provide me a vba for my above req

  5. #5
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    694

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    I am waiting ,and its being so long,as many of my post have closed within day, and this post is pending for more than three days..no attention...its an easy job for you people, if any thing else req,kindly guide and help me

  6. #6
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    694

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Plzzzz help as time is moving..

  7. #7
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    694

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Very strange that no body has attempted yet..is it that much tough

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Hello ROHAN999,

    Scrapped the Workbook as a solution.

    Please see my last Post.
    Last edited by Winon; 09-01-2013 at 07:28 AM. Reason: Not the right solution

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,891

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    ROHAN999, please read rule 13...
    13. Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

    Want to get your question answered quickly?
    Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
    On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
    Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
    Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
    Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
    If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

    In other words, please wait at least a day before asking for help on your thread again

    Thanks
    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

  10. #10
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    @ FDibbins,

    13. Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
    Oh my, but you are sharp!

    Is this indeed a cross posted Thread, and if so, where?

    In which case I shall immediately unsubscribe from this Thread.

    Jy het hom goed in die bek geruk!!!

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,891

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    @ Winnon, no, it was actually the highlighted part, regarding waiting a day before "bumping" the thread

  12. #12
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    @ FDibbins,

    Thank you for the clarification.

    Just maybe I am English "tired", and misunderstood the essence of your post.

    Actually, HaHoBe is also trying his best to "Wake me up"...LOL.

    Best regards!

  13. #13
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Winon,
    I hope Rohan999 takes FDibbins' advice on board. I have seen many of Rohan's thread has remained unanswered simply because he/she does not spend much time in explaining his/her request, nor does his/her the attachment help. This is not a way interpreted as criticising Rohan999, rather trying to help.

  14. #14
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Hello ROHAN999,

    The attached Workbook, "Copy Columns Sample(2).xls", replaces the Data on the "Final Sheet", whereas the other Workbook, "Copy Columns Sample(A).xls", appends Data on the "Final Sheet".

    Take your pick!

    You may also click on the *(Star) to the far left at the bottom of this post, to add to my Reputation.
    Attached Files Attached Files

  15. #15
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    @ AB33,

    I hope Rohan999 takes FDibbins' advice on board., ...This is not a way interpreted as criticising Rohan999, rather trying to help.
    AB33, I am very positive that Rohan will now, after all this, "shape up", to the high standards of this Forum.

    Thank you for your interest, feedback and help, it is allways most welcome.

  16. #16
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    694

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    So nice to c all of your help and advice

    i am extreamly greatful to this forum and all of you

    even i have suggested many of my friends to register here

    many of my friends are giving hits!!

    Thank you!!

  17. #17
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Move coulumns data of a sheet to diff other columns of other sheet in same workbook

    Hello ROHAN999,

    Thank you for adding to my Reputation.

    If you are satisfied with the solution I had given you, then please mark your Thread as Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Move Row Data to another sheet in same workbook
    By bucs25746 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-18-2013, 12:59 PM
  2. [SOLVED] Linking Templates to diff sheet in same workbook?
    By jazz56 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-17-2013, 11:22 AM
  3. Replies: 19
    Last Post: 02-08-2013, 05:59 PM
  4. [SOLVED] VBA. Move data from certain columns to another sheet, stacked up
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 06:46 PM
  5. Excel 2007 : Macro copy sheet into diff workbook
    By sirrahhc in forum Excel General
    Replies: 2
    Last Post: 05-03-2009, 01:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1