sir i have three sheet in excel..first sheet i have many colounm with filder option..in second sheet i have same coloum with filder option .IN third sheet also same ..sheet name only varying ..what i want is in first sheet i have one colounm name is form with filder( C,F,S)..IF I select c many rows are displayed..in second and third sheet also selcting C ..i should open one new sheet and put sheet 1 and sheet2 and sheet 3 (what are the rows are dispalyed if i select C )..in new sheet if i open and selct the coloumn form (C) some rows are displaying..i want sheet name before displaying the rows( sheet 1,sheet 2 ,sheet 3)
Jump to Post
Sorry, I'm really confused as to what you require?! Perhaps if you upload a workbook with a before and after scenario we can work something out for you. You'll have to zip the file to upload onto Daniweb.
Jump to Post
Hi karthikav, please upload a workbook as per my suggestion in my previous post. I understand your urgency but I have no idea how your data is laid out and therefore any answer I try to come up with will be based on me guessing, which will not get this …
All 7 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.