Report Automation

F

ForgetfulNerd

New Member
Joined
Nov 10, 2021
Messages
1
Office Version
  1. 2019
Hello,

I've been trying to automate some reports that i make on weekly basis. I'm quite stumped with this one. Would appreciate it someone could point me in the right direction.

I'm making the report based on Sheet-Data.
Tried the Index match in first column to detect No from data but it does not show the next value.



Book1
ABCDEFGHIJKLMNOPQRS
1WeekWork dateChecked OnTag IDUserQA TagQA NameSupervisor IDSupervisorManager IDManagerAssignedUsedTotal AuditedCorrect Adherence #Incorrect Adherence #2Adherence %Tag AdherenceLogin Remarks
2Week101-11-202104-11-202138551Ashish158Aslam Shaikh17241Joseph3006James EikerSSRJGHSSROKH76185.71%FALSE
3Week102-11-202105-11-202144852Veena625Ramniwash Singh15813Abinesh3006James EikerSSRVNFSSRROJ21150.00%FALSE
Report
Cell Formulas
RangeFormula
Q2:Q3Q2=O2/N2
R2:R3R2=[@Assigned]=[@Used]
Cells with Data Validation
CellAllowCriteria
A2:A3ListWeek1, Week2, Week3, Week4, Week5




Below is the raw data i'm using

Book1
ABCDEFGHIJKLM
1Tag IDUserAssigned TagWork DateSupervisor IDTL NameAudit DateOverall StatusQA IDQAWeeksAdhrenceTag used
238551AshishSSRJGH01-10-202117241Joseph04-10-2021Pass158Aslam ShaikhWeek1NoSSROKH
338551AshishSSRJGH01-10-202117241Joseph04-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
438551AshishSSRJGH01-10-202117241Joseph04-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
538551AshishSSRJGH01-10-202117241Joseph04-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
638551AshishSSRJGH01-10-202117241Joseph04-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
738551AshishSSRJGH01-10-202117241Joseph04-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
838551AshishSSRJGH01-10-202117241Joseph04-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
944852VeenaSSRVNF01-10-2021625Ramniwash Singh04-10-2021Pass625Ramniwash SinghWeek1YesSSRVNF
1044852VeenaSSRVNF01-10-2021625Ramniwash Singh04-10-2021Pass625Ramniwash SinghWeek1YesSSRVNF
1144852VeenaSSRVNF01-10-2021625Ramniwash Singh04-10-2021Pass625Ramniwash SinghWeek1YesSSRVNF
1244852VeenaSSRVNF01-10-2021625Ramniwash Singh04-10-2021Pass625Ramniwash SinghWeek1YesSSRVNF
1344852VeenaSSRVNF01-10-2021625Ramniwash Singh04-10-2021Pass625Ramniwash SinghWeek1YesSSRVNF
1438551AshishSSRJGH02-10-202117241Joseph05-10-2021Pass158Aslam ShaikhWeek1NoSSRJGH
1538551AshishSSRJGH02-10-202117241Joseph05-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
1638551AshishSSRJGH02-10-202117241Joseph05-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
1738551AshishSSRJGH02-10-202117241Joseph05-10-2021Pass158Aslam ShaikhWeek1YesSSRJGH
1844852VeenaSSRVNF02-10-2021625Ramniwash Singh05-10-2021Pass625Ramniwash SinghWeek1NoSSRROJ
1944852VeenaSSRVNF02-10-2021625Ramniwash Singh05-10-2021Pass625Ramniwash SinghWeek1YesSSRVNF
Data
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You must log in or register to reply here.

Similar threads

G
  • Solved
Sort/filter formula used for search formula combobox issue with shorter named values, Formula help for search combobox
Replies
6
Views
533
Akuini
Akuini
G
  • Solved
Combobox search dropdown triggering when editing other sheets
2
Replies
10
Views
545
Akuini
Akuini
T
  • Question
Flattening a hierarchy from 5 columns into a unique one
Replies
1
Views
470
Kerryx
K
V
  • Question
Returning Randomly Selected Value from Table based on Criteria
Replies
4
Views
594
Viau1337
V
J
  • Question
Guidance on created a automated report with VBA
Replies
2
Views
469
Jeff_Fuzzy
J

Forum statistics

Threads
1,214,951
Messages
6,122,449
Members
449,083
Latest member
Ava19

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top