Welcome to the forum!
On the first sheet you have a form or something similar.
Or what do you have on the first sheet?
Each row on the first sheet is a record. How to know which record to copy to the hospital sheet?
What data do you want to copy and exactly where do you want to paste them?
You could give some examples.
Hi,
On the first page is like this the hospital and ward are both drop down lists with all four sites and all wards, each site has their own sheet with the 'A' column and row 2 titles going across the pages. I have put a site page example below this one.
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1001"]
<colgroup><col width="112" style="width: 84pt;"><col width="71" span="4" style="width: 53pt;"><col width="103" style="width: 77pt;"><col width="76" style="width: 57pt;"><col width="71" span="6" style="width: 53pt;"></colgroup><tbody>[TR]
[TD="class: xl88, width: 112"] [/TD]
[TD="class: xl89, width: 71"]Hospital[/TD]
[TD="class: xl115, width: 142, colspan: 2, align: center"]GGH[/TD]
[TD="class: xl90, width: 71"]Ward[/TD]
[TD="class: xl96, width: 103"]Antenatal[/TD]
[TD="class: xl91, width: 76"] [/TD]
[TD="class: xl91, width: 71"] [/TD]
[TD="class: xl91, width: 71"] [/TD]
[TD="class: xl91, width: 71"] [/TD]
[TD="class: xl91, width: 71"] [/TD]
[TD="class: xl91, width: 71"] [/TD]
[TD="class: xl92, width: 71"] [/TD]
[/TR]
[TR]
[TD="class: xl93"][/TD]
[TD="class: xl85, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Ward Manager/ Junior Sister[/TD]
[TD="class: xl86, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Staff Nurses[/TD]
[TD="class: xl87, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Student Nurses[/TD]
[TD="class: xl86, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Specialist Nurse [/TD]
[TD="class: xl87, width: 103, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Consultant[/TD]
[TD="class: xl95, width: 76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Senior Doctors e.g Registrars[/TD]
[TD="class: xl72, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Junior Doctors FY1, FY2[/TD]
[TD="class: xl71, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]HCA.s[/TD]
[TD="class: xl72, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Therapies[/TD]
[TD="class: xl71, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Hotel Services, Porters etc [/TD]
[TD="class: xl73, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Others i.e SW, ECG, Techs, Admin Ambulance, Lab Staff[/TD]
[TD="class: xl74, width: 71, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl75, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Opportunities for Hand Hygiene [/TD]
[TD="class: xl76, align: center"]5[/TD]
[TD="class: xl76, align: center"]9[/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"]2[/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl112, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Hand Hygiene Tool [/TD]
[/TR]
[TR]
[TD="class: xl75, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]No of times Hand Hygiene performed [/TD]
[TD="class: xl76, align: center"]5[/TD]
[TD="class: xl76, align: center"]5[/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"]2[/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl77, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C5D9F1]#C5D9F1[/URL] , align: center"]Compliance Rate for Each Dept.[/TD]
[TD="class: xl83, align: center"]100%[/TD]
[TD="class: xl83, align: center"]56%[/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"]100%[/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl94, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"]1) Before Pt Contact[/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl78, align: center"] [/TD]
[TD="class: xl106, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"]Type of Decontamination Missed [/TD]
[/TR]
[TR]
[TD="class: xl94, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"]2) Before a clean/ aseptic procedure[/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl94, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"]3) After Body fluid Exposure, 4) After pt contact 5)After contact with the Environment [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[TD="class: xl76, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl79, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC0DA]#CCC0DA[/URL] , align: center"]No Staff Observed[/TD]
[TD="class: xl80, align: center"]6[/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl109, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B1A0C7]#B1A0C7[/URL] , align: center"]Bare Below Elbows Observation[/TD]
[/TR]
[TR]
[TD="class: xl79, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC0DA]#CCC0DA[/URL] , align: center"]No Bare Below Elbows[/TD]
[TD="class: xl80, align: center"]4[/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[TD="class: xl80, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl81, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC0DA]#CCC0DA[/URL] , align: center"]Compliance Rate for Each Dept.[/TD]
[TD="class: xl83, align: center"]67%[/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[TD="class: xl83, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl82, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8DB4E2]#8DB4E2[/URL] , align: center"]Total Opportunities of Handwashing [H][/TD]
[TD="class: xl78, align: center"]16[/TD]
[TD="class: xl97, colspan: 11, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl82, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8DB4E2]#8DB4E2[/URL] , align: center"]Total number of times Hand Hygiene Performed [0][/TD]
[TD="class: xl76, align: center"]12[/TD]
[/TR]
[TR]
[TD="class: xl82, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8DB4E2]#8DB4E2[/URL] , align: center"]Area/Ward HH Compliance Rate[/TD]
[TD="class: xl83, align: center"]75%[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC0DA]#CCC0DA[/URL] , align: center"]Total No Staff Observed BBE[/TD]
[TD="class: xl84, align: center"]6[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC0DA]#CCC0DA[/URL] , align: center"]No. Staff BBE[/TD]
[TD="class: xl84, align: center"]4[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 112, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC0DA]#CCC0DA[/URL] , align: center"]Area/Ward BBE Compliance Rate[/TD]
[TD="class: xl83, align: center"]67%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Site page example[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 1775"]
<colgroup><col width="71" span="25" style="width: 53pt;"></colgroup><tbody>[TR]
[TD="class: xl97, width: 497, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , colspan: 7, align: center"] [/TD]
[TD="class: xl91, width: 639, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , colspan: 9, align: center"]Ward Manager/Junior Sister[/TD]
[TD="class: xl93, width: 639, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , colspan: 9, align: center"]Staff Nurses[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFFF]#CCFFFF[/URL] , align: center"]Ward[/TD]
[TD="class: xl77, width: 71, bgcolor: silver, align: center"]Opportunity for compliance (insert %)[/TD]
[TD="class: xl75, width: 71, align: center"]Total Opportunities[/TD]
[TD="class: xl75, width: 71, align: center"]Total No of times decontaminated hands[/TD]
[TD="class: xl75, width: 71, align: center"]Total Staff observed Bare Below Elbow (BBE)[/TD]
[TD="class: xl75, width: 71, align: center"]No of Staff BBE[/TD]
[TD="class: xl75, width: 71, align: center"]Area/Ward BBE Compliance % [/TD]
[TD="class: xl82, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , align: right"]Opps[/TD]
[TD="class: xl82, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , align: right"]No of times Decontaminated Hands[/TD]
[TD="class: xl84, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , align: center"]Staff % Compliance[/TD]
[TD="class: xl83, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFFF]#CCFFFF[/URL] , align: center"]No Staff Observed[/TD]
[TD="class: xl83, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFFF]#CCFFFF[/URL] , align: center"]No BBE[/TD]
[TD="class: xl78, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFFF]#CCFFFF[/URL] , align: center"]Compliance %[/TD]
[TD="class: xl73, width: 71, bgcolor: #FFFF99"]1) Before Pt Contact[/TD]
[TD="class: xl74, width: 71, bgcolor: #FFFF99"]2) Before a clean aseptic Proceedure[/TD]
[TD="class: xl74, width: 71, bgcolor: #FFFF99"]3) After Body Fluid Exposure 4.)After Pt Contact 5) After Contact with Pt immediate Surroundings[/TD]
[TD="class: xl85, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , align: right"]Opps[/TD]
[TD="class: xl85, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , align: right"]No of times Decontaminated Hands[/TD]
[TD="class: xl89, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7DEE8]#B7DEE8[/URL] , align: center"]Staff % Compliance[/TD]
[TD="class: xl86, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFFF]#CCFFFF[/URL] , align: center"]No Staff Observed[/TD]
[TD="class: xl86, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFFF]#CCFFFF[/URL] , align: center"]No BBE[/TD]
[TD="class: xl86, width: 71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFFF]#CCFFFF[/URL] , align: center"]Compliance %[/TD]
[TD="class: xl87, width: 71, bgcolor: #FFFF99"]1) Before Pt Contact[/TD]
[TD="class: xl88, width: 71, bgcolor: #FFFF99"]2) Before a clean aseptic Proceedure[/TD]
[TD="class: xl88, width: 71, bgcolor: #FFFF99"]3) After Body Fluid Exposure 4.)After Pt Contact 5) After Contact with Pt immediate Surroundings[/TD]
[/TR]
[TR]
[TD="class: xl79"]A&E[/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[/TR]
[TR]
[TD="class: xl81"]Antenatal[/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[/TR]
[TR]
[TD="class: xl80"]Cadog[/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl90"] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sorry if images not aloud. All figures are made up and nothing is confidential.
Thanks
K. Stevens