Dear Paul/Vaibhav Thanks for reply. *To Vaibhav,* Macro you send is just merging the data from all sheets in one sheet.My requirement is something different which I tried to explain below
To Paul, Do you have any experience with macros? *Yes but I can write very basic macro.* or are you asking one of us to CREATE one and show you how to use it? *As i answerd first question it will be better if someone write and give it to me * (which is POSSIBLE, but implies more of a time commitment) *.Ok * to do either, we'd need to know what your two worksheets look like and what exactly you want the results to look like. *About My requirement.(To vaibhav and Paul)* Threae are 2/3 sheets Trial 1 and Trial 2 and so on which contents same no of rows basically sheets are exactly same only data will be vary.For exapmle we will consider there are 2 sheets. Now I want data of both sheets in one sheet in following way. Suppose there are 10 rows in each sheet (Rows 1 to rows 10),then there will be 20 rows in results sheet. In resuts sheet there will be 1st row from 1st sheet then 1st row from 2nd sheet then 2nd row from 1st sheet then 2nd row from 2nd sheet and so on. In case of any more doubt please ask Thanks once again Regards Shrinivas On Tue, Feb 3, 2015 at 6:42 PM, Vaibhav Joshi <v...@vabs.in> wrote: > Hi > > Use this sheet to merge all sheets data in one sheet.. > > Cheers!! > > On Tue, Feb 3, 2015 at 1:02 PM, Shrinivas Shevde <shrinivas...@gmail.com> > wrote: > >> Dear All >> Please help me for following problem >> I used to get the data in 2 sheets Trial1 and Trial 2 >> I need to conoslidate this data in 3rd sheet "results" >> It is very time consuming process.As I need to insert row after every row >> of Trial 1 and copy paste from Trial 2 (there are more than 150 lines ) >> So can any one give me macro for this activity. >> Thanks in advance >> >> Regards >> >> -- >> Shrini >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
