Get instant live expert help with Excel or Google Sheets

I need your help writing a vba code. In an insurance company each month the number of policies varies. I am working with a program that outputs the policies and their specs in an Excel worksheet. If I want the code to stop execution on the last policy (sometimes there are less policies and sometimes there are more) what should I write? For example if last month they had 5000 policies and this month 4500 I want excel to remove the last 500 but if this month they have 6000 I want excel to add the extra 1000 policies.

I'm curious to know if a excel document can be created to track the quantity of total product that has been sold with prices. Information gathered within the Excell workbook? HELP?!

Help with a case study involving excel analysis - create a dashboard?

My Worksheet image is in Below Link. My Excel Sheet Image Information About Competitions situation: I am a school teacher. The worksheet is about to practical "Yogaasana" test of students'. In this practical exam there are four member of Judges Panel. The First main Judge is for decided about which "Yogaasana" is performed by the student. The other three judges are called Referee whose work is only for marking according to student's "Yogaasana". Information About Worksheet : The Heading name column has the names of students. There are three referees. All referee has a score sheet. In the score sheet there are seven cells. The referee must have to put every student's marks on respective cell. The marks are must be out of 10. I put "C" for First six column of each referee and put "O" for last seventh column. That means the student have to Do a first six "Yogaasana" compulsory as per the ordered by the First main judge. And the "O" means Optional "Yogaasana" which is performed by the student's as per his or her own choice. The Referee-1 Total, Referee-2 Total and Referee-3 Total column has the total of the student's obtained mark's out of 70. The Grand Total column has all Judges' Marks total out of 210. Final 2nd Highest column has second highest referee's Grand total. Criteria of getting Top Five students' :We give first place for that student who highest marks in the Final column. The Final 2nd Highest column has the second highest referee's Grand total. It means we ignore the highest referee and lowest referee's mark. In case of Tie situation : In case of Tie we use following method as per It's order. Means first use 1 If tie not solve than use 2. 1) If the one or more student's marks are same than go to the Second highest referee's sheet and see only last Optional "Yogaasana" marks for give the student first rank. Means student A, Student B and Student C has the same mark than goto the second highest referee's sheet and see the last "O" columns marks. For example If A has 8, B has 7 and C has 9 marks than First ranker is Student C, Second ranker is A and Third one is Student B. 2) If the again one or more student has second highest referee's column "O" marks are same than go to the All referee's grand total column which has marks of out of 210. Than find the student's which has tie and give the first rank for that student who has highest All referee's Grand total. For example If Student A, Student B and Student C has the same marks in above condition one and their All referee's Grand total marks are 201 for Student A, 203 for Student B and 204 for Student C than the first ranker student is C, Second ranker is B and the third one is A. 3) If the again Tie than we decide manually by toss the coin. I stuck at Large function : I do the excel sheet as per my Excel knowledge but I stuck at Large formula. You see the formula I use in Formula bar of Image. So, anyone can please help me for the same and solve my problem as per the above condition. Thanks in advance

Hi, I'm a (very) old timer trying to learn a little about VBA to keep my mind alert! The aim of the project is to help people with memory problems by sending email reminders when actions become due. Problem: Loss of formatting in email (Outlook) via Excel VBA & Office 2010. All help sites consulted but to no avail. The limiting factor is probably my lack of expertise! I've unashamedly copied piece of code from others and my sole remaining problem is formatting. Happy to send code. Would be exceedingly grateful for any help please.

Loss of formatting when sending email from Excel 2010 via vba - text becomes concatenated - Many help sites consulted but to no avail. Possibly lack of expertise on my part. Help will be greatly appreciated please. Its a project to help people with medical problems. Cab send vba used.

I am working in Excel and have a series of numbers and wish to have a query that looks at three criteria and determines a specific value depending on the criteria chosen. In my case, I have a series of rates for a job and the rate varies depending on three criteria which are chosen in the previous columns. Can you help guide me to the correct commands?

Hello! I need help with Excel. I need to transfer values from 2 or more columns to 1 column.. Is there any easy way to do it? Thank you!

Hello, I am trying to write a formula on Excel for cumulative tiered pricing and would like some assistance. Here's my example: 1 - 25 units = $100/unit 26 - 50 units = $85/unit 51 - 100 units = $70/unit More than 100 = $55/unit These are example results: 26 units = (25*100)+(1*85) 75 units = (25*100)+(25*85)+(25*70) I am trying to write a formula using sumproduct, but it only works for calculations from 1-25 units, and not above that. Any help on this would be greatly appreciated!

Hello, I'm trying to create a custom daily schedule with excel and need help finding a template to use as base for the personalized one I intend to create. Could you please help me?