Search results

Hello Helpers, Kindly refer attached sample file. Row 4 contains subject name. Row 5 contains teacher name. Same Subject name may appear more than once as the subject may be shared by multiple teachers. Row 6 to row 11 contains student data (there can be more rows of student data). Column B...

Hello Helpers, I want to count total no. of entries from a tabular data based on multiple criteria. I tried many formula like countif, sumproduct but it is not working. I have an excel file containing total 5 sheets. Original_data, Attendance_data, register, temp and final. Original_data...

Hello helpers, I have one excel file containing 2 sheets - Data and Report. Data sheet has multiple rows having date wise tasks performed by one teacher. Each task is included under some heads (section) like exam, activity, seminar etc. Teacher will keep on adding data in rows date wise. There...

Hi Helpers, I am entering dates in dd/mm/yyyy format in column B. Format of this column is text. I am using text function to display day in column C. So, far it was working perfectly. But today, when I entered date 02/06/2024, it has started showing TUE in place of SUN. I found the reason...

Hi Helpers. I have an excel sheet to get faculty wise timetable (Monday to Saturday). In this sheet, I enter faculty code and based on this short code, data will be filled in the table. I can then save this excel sheet as pdf and give it to respective faculty. But this is time consuming because...

Dear Helpers, I have used following array formula for calculation in my excel sheet and it works fine. cell e3 has formula {=IF($B3<>"",IF(SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$101:$A$120&"'!$b$127:$b$132"),$B3))>0,E$2,""),"")} cell f3 has formula...

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

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

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

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

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

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.

Hello Helpers, I have multiple sheets each having 3 types of list. Refer Group_1, Group_2 and Group_3 sample sheets of testing excel file attached here. Row number 1 to 10 is reserved for CEO position entry. Row 1 is title and 2 to 10 is for names. Row number 11 to 20 is reserved for Secretary...

Hello helpers, I have column A in my worksheet in which I am pasting list of values which contains duplicates. Number of values to be pasted will vary every time. Now I want to create unique list in column C. I have used one array formula in column C to generate unique list. But my formula is...

Hello helpers, I have following code to concatenate multiple cells based on condition. I have range of cells from b17 to p17 having some text. I have a word in A26. I am searching A26 in b17 to p17 and if match is found then corresponding cells from b16 to p16 will be concatenated with : as...

Hello helpers, I have attached sample workbook here. I have multiple classes in my school and my sample workbook contains timetable of 2 grades - grade_8A and grade_8B. There can be multiple grades. There are many teachers who takes combined sessions in more than one grades. There can be more...

Dear Helpers, I have an excel sheet with students data like roll number, name and the answers they have given in quiz. Sample file: A2 to E5. c2, d2 and e2 are correct answers of Q1, 2 and 3. I want to calculate total marks obtained by each student. For that i have created table in H3 to J5...

Hello Helpers, I have an excel file with 2 sheets. supervision_chart and individual supervision. supervision_chart has date wise list of supervisors. I need to generate supervision chart for each supervisor in individual_supervision sheet. When I type supervisor code in B5 cell of...

Dear Helpers, My school has 10 grades from 1 to 10. Each class has number of subjects and each subject is taught by one or more teachers. Now, each teacher is teaching in different grades. And he / she is maintaining attendance sheet of each class in one workbook. Say teacher A is teaching in...

Dear Helpers, I want to automatically fetch the data from multiple workbooks into one workbook. Let me explain the scenario. There are total 10 classes (subject to increase) of different grades in my school. Each class has to study different subjects and each subject may be taught by more than...

Hello Helpers, I have an excel sheet "list" in which there is list of participants of different games is placed. This list can be updated and new participants can be entered. Now there are 3 games so there are 3 sheets with name "game-1","game-2" and "game-3" I have shown sample output required...

Hi Helpers, I have one excel file which is created to manage timetable of one educational institute. It contains many excel sheets. Main worksheet is timetable. It contains many slots. Each slot has two lines - upper line is for subject and below line is for faculty name. Master timetable is...