In the workbook, it has 4 sheets :- Input1, Input2, Input3 & Output. I simply want to merge the contents of Input1, Input2 and Input3 to sheet "output". "Output" sheet should also include a column G where it simply writes "Zero" if the column F is 0 or 1 with "One" or 2 with "Two".
Number of rows in sheets "Input1, Input2 & Input3" are not fixed. I get sheets daily where number of rows can be anything from 1 to 1000.
Please download the excel sheet attached and it would be crystal clear to you.
Does this help?
Please Login or Register to view this content.
You could try this one too.
Please Login or Register to view this content.
Last edited by kadeo; 09-19-2016 at 03:39 PM.
Please click *Add Reputation if I've helped
Thank you john and kadeo. Problem is solved.
Hi, john and kadeo. One more question. What if i just want to add a text and drag and drop it. Let me explain, first the code will copy the data from sheet "Input1" and paste it to "Output" sheet. It will than add a text e.g "Firstdata" at cell G2 and than simply drag and drop this text till the last row.
Then the code will copy the data from sheet "Input2" and paste it to "Output" sheet starting from last row and then add a text e.g. "Seconddata" at cell(whatever be the last, first empty cell of column G) and than simply drag and drop this text till the last row.
Similarly, the code will copy the data from sheet "Input3" and paste it to "Output" sheet starting from last row and then add a text e.g. "Thirddata" at cell(whatever be the last, first empty cell of column G) and than simply drag and drop this text till the last row.
I hope you get my point.
I don't entirely get your point, but if you want to have several cells contain the same value you just need to specify it in the range. For instance, if you wanted to make the value of cell C3 be "Hello world" you would do it like this:If you wanted to do the same with cells C3 to F8 you would do either of these:Please Login or Register to view this content.Does that help?Please Login or Register to view this content.
Perhaps?
Please Login or Register to view this content.
kadeo, you missed my point. I have attached another excel sheet which explains it clearly. Please download.
Hi John. Thank you for your help but in the second example, I don't need any case (Case Is = 0 ,1 or 2). Please download Sample1 as attached in above post.
Amending my original example you can get this:Please Login or Register to view this content.
Last edited by kadeo; 09-19-2016 at 04:09 PM.
Not exactly as you want, but maybe:
Please Login or Register to view this content.
Thank you kadeo and john. Actually I require both of these codes
You're welcome. Glad to help out and thanks for the feedback and reps.
No bother man. Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks