Search results

ok. Can you just tell me how to modify title of thread?

Thank you all. I finally could create my required VBA code after searching a lot and many times trial and error method. Now my VBA code is working perfectly as per my requirement. @Monty sir, your VBA code gave me strong base. Thank you once again.

If I have got the solution then can I close my thread? How?

I received VBA code from Monty sir in this forum for my problem. I tried to understand the code and make changes in VBA code to suit to my requirement. I tried a lot but I couldn't implement above mentioned 2 features. So I am asking for help.

Hello Monty sir, I have solved almost all issues that I was facing. I have done changes to your code. Now, my event sheets are not deleted. My data started being pasted from row 4 in consolidated sheet. My data is sorted on enrollment number in consolidated sheet. But I could not find answer...

Sir, different teacher may type different class name in F3 cell of event_list sheet. And based on their class name, it should fetch data from all event sheets and generate list of students of the respective class in consolidated sheet. For this, event sheets can not be deleted. Sir, you have...

Hello Monty sir, I tried your code. But, 1. It deletes the events sheets. I need to keep the events sheets. 2. In the consolidated sheet, 3rd row is header row. It should remains as it is. Data should be pasted from 4th row. 3. It should paste column B to column I from each event sheet based...

I have attached file. Please help.

Sir, Kindly refer attached file. I have already added your code. But the problem is, it is not generating any output in consolidated sheet. Sir, I am entering my required class in F3 cell of "event_list" sheet. Consolidated sheet must generate list of students of inputted class (in F3 cell )...

@Monty sir, you have provided me below given solution for my problem of generating consolidated sheet based on multiple sheets. But it is not working. Kindly help. >>> You've noted many times <<< >>> use code - tags <<< Option Explicit Sub GenerateConsolidatedList() Dim wsEventList As...

Hello Monty sir I was talking about below problem, Trying to explain my problem. I have an excel file for maintaining list of students participating in various events of an institute. I have one sample excel which contains 4 sheets right now. First sheet "event_list" has list of sheet names...

https://chandoo.org/forum/threads/generate-consolidate-list-dynamically-from-multiple-sheets.55699/#post-303262

Sorry for bothering you once again but I need your help in my another thread as well. There also you have sent me vba code but it is not working or else I am doing something wrong somewhere. Please help.

Respected Helper, It worked perfectly. Thank you soooooooooooooooo much.

you helped me with vba code. I inserted that code in my excel sheet which i have saved now as macro enabled worksheet. But not getting consolidated sheet. Please help. Attaching new file with vba code. Here, I have tried adding one more sheet of sports.

Sir, In previous thread, I received answer with power query which is not available to and we are very basic users us so we couldn't understand even. One solution was given with formula but we failed in first step. I replied also that we couldn't proceed from first step. I waited in that thread...

Hello Helpers, Trying to explain my problem. I have an excel file for maintaining list of students participating in various events of an institute. I have one sample excel which contains 4 sheets right now. First sheet "event_list" has list of sheet names under column title "Event Sheet...

Hello helpers, I have an excel files with almost 30 sheets. My first sheet is named menu. On menu sheet, I have multiple sheet names from a5 to a15 (11 names are written) . for e.g. task1, task5, task7, task11 and so on. My file contains sheets with these names. I want vba code to be attached...

Hi helper, Your first step is not working so i am unable to proceed. On the "consolidate" sheet: 1. Class Lookup: - In D4, enter the following formula to look up the class for the corresponding event in C3: =IFERROR(VLOOKUP($B4, INDIRECT("'" & C$3 & "'!$B$4:$C$100"), 2, FALSE)...

Hello Helpers, I have for example 4 sheets right now. First sheet "event_list" has list of sheet names under column title "Event Sheet Title". Right now there 2 names in cell b4 and b5 - tennis and cricket respectively. Note: There can be new sheets of new sports events can be added in future...

Sir it is not working. I added $. But when i drag, it remains $d4 in next cell. I am dragging horizontally.

Sir it is not working. I added $. But when i drag, it remains $d4 in next cell. I am dragging horizontally.

Hello Helpers, I have written a formula =IF(Basics!D4="","",Basics!D4) in cell D5 of one worksheet. Now I want to drag formula in E5 to O5. Formula of E5 should be =IF(Basics!D5="","",Basics!D5) Formula of F5 should be =IF(Basics!D6="","",Basics!D6) and so...

Hello I have 4 worksheets in one workbook with title timetable, MON, TUE, WED I have one dropdown list in h4 cell of timetable worksheet with values MON, TUE and WED. timetable sheet contains empty table with same format as MON, TUE and WED sheet. I want to copy table values from B8:T15 and...

Hi Helpers, My excel file contains VBA code and it is working perfectly. Various colors are shown in timetable sheet is due to VBA code. But I am not able to see VBA code. Help please.