multiple records

I am working on creating a wellness and physical fitness dashboard and understand how I can create a Userform using VBA to add/edit a single record but am wondering if it is possible to add multiple records when entering groups of like data (Body Msmts, Hematology, Cardivascular, Chemistry...

I have an Excel Spreadsheet contains 8,000 rows by 30 columns. I am trying to count the number of National Insurance numbers in column F where column S = FAMC and column T = NP. I am trying to count the occurrence of National Insurance numbers that contain this criteria, however, if the nation...

I created a form where by using a COUNT:=SUMPRODUCT((TEXT(Order!A2:A65535,"m/dd/yy")=TEXT('Order Confirmation'!$J$34,"m/dd/yy"))*(((Order!J2:J65535>=1)+(Order!I2:I65535>=1))>0)*(Order!A2:A65535<>"")*(Order!J2:J65535<>"")*(Order!I2:I65535<>""))...

Thank you for reviewing my post. When double-clicking a PivotTable value, how does one limit the records displayed? For example, it makes intuitive sense to see only one record, when double-clicking the value of 1 in the following PivotTable: However, I get the following nine records...

I have a data table with many records each including an event date. I then use queries to extract and sort data that meets certain criteria. My question is how can I calculate the interval between the dates in successive records. What I need is to show the number of days since the previous...

I have been working on this for a bit on my own and trying to figure out the best way to approach it, but I am going in circles, so here goes. I have a database of folks with some unique identifiers, but I want users to be able to search/lookup by last name, which obviously may not be unique...

I'm having a bit of trouble getting a macro to run. I have a sheet with personnel No's UserID's and Email address as below: <TABLE style="WIDTH: 488pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=650 border=0 x:str><COLGROUP><COL style="WIDTH: 47pt; mso-width-source: userset...