Search results

Thank you so much helper. It worked perfectly. Thanks again.

>>> How many times have to give same note? <<< >>> use code - tags <<< Application.CopyObjectsWithCells = False 'copy your sheet ActiveSheet.Copy Application.CopyObjectsWithCells = True 'reset With this lines of code, my 2 shape button and one picture image will not be copied in new...

I have written below code to copy current worksheet to another workbook at desired location. This VBA code works perfectly. My current worksheet has 2 buttons and one image. I have used Application.CopyObjectsWithCells = False and Application.CopyObjectsWithCells = True for not copying objects...

ws.Cells(i, 10).Value = Application.WorksheetFunction.CountIfs(rng, ">=" & CLng(startdate), rng, "<=" & CLng(endDate)) changing this line solved my problem as suggested by p45cal and Debaser. Monty sir, I was worried because my data formats were double checked. I incorporated changes given by...

Sir, I incorporated your code but it is still giving 0. reference file is attached here.

Well, I do not have any such option. But thanks for information.

>>> You've noted many times <<< >>> use code - tags <<< Set ws = ActiveWorkbook.Sheets("Consolidated") lastrow = ws.Cells(Rows.Count, 1).End(xlUp).Row Set rng = Range("n6:n65") For i = 6 To lastrow If Cells(i, 4) <> "" Then startdate = Cells(i, 7)...

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...