point

Good morning, I now need to save the project I created in Excel 2010 as Excel 97-2003 so that my boss can try it out. Can anyone point me to a method or tool for checking compatibility of my current macros with Excel 2000? thanks much, Bill

I have a pivot table with inventory reports for a number of schools. I need to copy each school's section individually from a pivot table and paste on another sheet. Once I find the starting point for a particular school, I can use xlDown to set the correct number of rows. However, I need the...

I am creating a scatter plot in excel with over 180 points. With that many points I am not able to use data labels to show which point is for what item. Is there a way that I can change the y variable within the data point to point to the item of the y axis? Thank you

As you can see from the formula, I'm attempting to get point values from one time to the next in half-point increments. Not even halfway through the formula, I ran a test and it said there were too many levels of nesting. It will place the point values up to about the 9 point mark, but not...

I have a set of financials that link to a PPT for our monthly presentations. Each fiscal year we create a new excel WB. Everything is exactly the same, the only difference is the name of the file. So instead of the excel file saying FY18, it now says FY19 Is there a way to point the PPT to...

Hi all, I use Excel frequently, but would only dare say I'm proficient with the basic processes. I need to import several thousand lines of inventory data to an online inventory program via a csv file. The new program I'm using only allows me to import one data field for ALL the bullet points...

Hi there, I have a spreadsheet which I need to replace a users keystroke with a bullet point when they type. I thought that the # key would be suitable as it doesn't have much use in this document... I was hoping to use some code such as: Application.OnKey "#", "addBulletPoint" so that when...

Hello everyone, Maybe you are familiar with word Gerber, maybe you are not. It's a file that contains X/Y coordinates, it's most commonly used in different types of Industries, mainly PCB manufacturing and PCB assembly. I need excel to translate form1 to form2 Form1 Examples: %FSLAX24Y24*%...

There are some of the Subs that when I call them from the standard module with my userform, I get errors so I have to place them in the userform module. I have not used the class module before. Can someone point out to me whether I am doing the right thing or not? Regards Kelly

Book1ABCDEFG1StartEndLocationLocationStartEnd21.101.20Point 1 >> Point 2Point 1 >> Point 20.002.3036.506.80Point 3 >> Point 4Point 2 >> Point 32.306.1042.352.60Point 2 >> Point 3Point 3 >> Point 46.107.8059.509.80Point 5 >> Point 6Point 4 >> Point 57.809.2063.604.60Point 2 >> Point 3Point 5 >>...

Hi, Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible. scenario: Total number of items = 39 For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and For each item...

Hi, Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible. scenario: Total number of items = 39 For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and For each item...

I have tried to simplify this in my small brain and try to present it to this forum in a manner which respected their time (and solicited a quick/ easy answer). But when I try to simplify, I lose the challenge. Basically I am confusing myself. Is there anyone who could take a look at this and...

I had a hard time thinking of a good title for this since it is hard to explain. here is what I am hoping to achieve... There are four individual games that are each worth a point. If someone wins the game, then they win 1 point. If nobody wins the game, then that point "carries over" and...

Is it possible to use excel to find if a particular set of coordinates falls within an area (composed of coordinates, like a fence)? In the example below, I have coordinates for all four corners of a made-up home, gym, and work site. I am trying to see if Excel is capable of recognizing what...

Ok, so I am creating an attendance sheet and I have it looking up the employee's # of points and letting it dictate by vlookup what level write up that employee is on. The catch is, if a employee has a no call no show they receive a point (like an absent) but also a right. Excel gives them the...

Hello Everyone, I am having difficulty in identifying and highlighting exact number matches between two lists. If this questions has answered could someone point me to the appropriate forum post ? Thank you everyone for your time...

Hello everyone, I am a little stumped at this point and I have tried multiple things (maybe I need some coffee lol). So I am building an attendance sheet for my company to use across the network. I am trying to make it more user friendly. We use a point system when it comes to attendance. I am...

I've been messing around with userforms and macros for a little bit but frankly I'm lost when I tried this one. I have pretty basic yes/no popups and have done macros to insert data into the next empty row, that sort of thing. Anyways. I have a userform that I am making using comboboxes and...

I have 3 columns of stock prices – the date, the low, the high, and the close. I am trying to build a formula (may have to be in multiple columns with each column having its own formula) that returns the A point price, B point price, and C point price of something called the ABCD pattern -- D is...