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
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
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] .
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
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
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
Plzzzz help as time is moving..
Very strange that no body has attempted yet..is it that much tough
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
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
@ FDibbins,
Oh my, but you are sharp!13. Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
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!!!
@ Winnon, no, it was actually the highlighted part, regarding waiting a day before "bumping" the thread
@ 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!
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.
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.
@ AB33,
AB33, I am very positive that Rohan will now, after all this, "shape up", to the high standards of this Forum.I hope Rohan999 takes FDibbins' advice on board., ...This is not a way interpreted as criticising Rohan999, rather trying to help.
Thank you for your interest, feedback and help, it is allways most welcome.
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!!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks