basic

Hi All, Any help is appreciated, I've been playing about with this trying to get the formulas right, assuming an IF formula, but not sure how to separate if it requires an answer between a certain range. For example, I'm trying to write cell formulas so whatever Gross income is entered it...

Hello, I am trying to find a way to build on the basic IF function. IF(logical_test, [value_if_true], [value_if_false]) I want to have a few options rather than just one, such as: if A1 = 1, B2 would autofill with Good if A1 = 2, B2 would autofill with Maybe if A1 = 3, B2 would autofill with Bad...

Hi everyone, Below i have attached table , from which i need to search for a column through column name and when it finds that column it should perform some tasks like 1.It should divide by 12 from all the values which are found 2.Only that column should be copied and pasted in another new...

Please excuse my newness to VB. I have a urgent task for work that I need to complete today, however I am stuck. I didn't think initially that I would need to use VBA to complete the task, but ultimately I do, and I am too new at it to complete it on my own. Below is the code with...

Hi I asked this question before and I got an answer. The answer was Visual Basic. Now I came to this link which says it is written in C++ https://www.quora.com/What-language-is-Excel-written-in Which one is the the right one. Thank you so much.

Hello! im just newbie in excel my question is what formula do I need to get just subjects of all Basic and Common type. My sample dataset; <tbody> Type Subject Basic Subject 1 Basic Subject 3 Common Subject 2 Core Subject 1 Common Subject 3 Core Subject 1 </tbody>...

Hi Everyone, I have below code to insert documents into excel Sub Insert_OLE_Object() Worksheets("Sheet1").OLEObjects.Add Filename:="c:\temp\sample.pdf", Link:=False, DisplayAsIcon:=False, Left:=40, Top:=40, Width:=150, Height:=10 End Sub I want to know how can i can run above code by...

Hello, I again come with a quick-fix problem (I think). I have a field (VisitorID) filled by users via a form. I want to ensure that the format is followed so data can later be searched. The format is AB-1234. That is, 2 letters, a dash, and 4 numbers. I want to make sure the first 2 are...

thought it might be easier to provide the basic idea with code rather than try to explain it. I am trying to take one record from "Entries" and paste into the "basic" worksheet, print the sheet (one per record , then clear contents for the next record to be copied and printed. End the end I...

Hi Everyone, Not had this before but everytime i insert a formula into a sheet I get an error pop up say Microsoft visual basic for aplications X 400 any ideas whats cousing it? Thanks Tony

I am new to this site however hopefully someone will take pity on me and answer my question. I should also say I am only a basic Excel user (very basic). Here is my problem. I have a spread sheet with a column that contains individual email addresses (example = JoeSmith@ABC.com). I need to set...

I am trying to learn loops. My vba code is: Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection...

Hello Newbie so please bear with. So, I want to pull a Value from a table using the lookup based on data in column A of a new sheet. I need to use the header rows of the table to find my Value as the number of columns will differ but the row header will not change. For example <tbody> Unique...

I have a cell with the value 125% in it, however I need to make the cell display the words "INCREASE BY 25%". Example: If cell A1 = 100, from a pull down menu in cell A2, I want the user to be able to select "INCREASE BY 25%". Having selected "INCREASE BY 25%", the value of cell A1 then needs...

Hello, I joined this forum in 2007. Back around then I took an intermediate excel class and I enjoyed it. My work at that time had me maintaining a couple of spreadsheets. this place was great. I haven't opened a spreadsheet in a decade until earlier this year. Now I'm managing some data on...

Hi, I use the formula =IF(LEFT(a2,6)="838021",RIGHT(a2,8),IF(LEFT(a2,6)="838086",RIGHT(a2,8),a2)) quite regularly. I was hoping to create my own custom function for this but i can't figure it out! My VBA is very basic, some help would be much appreciated. Thanks C

I have an audit coming up and I need to be able to find information quickly to satisfy the auditor At A1 I have the thing I need information on this is my search box : A1= Risk assessment ( I want to know which clause this is under ( the clause # ) and what the clause says) B1: B52 = a...

Hi all, I want to give the user options which are conditional on another cell. For example, in cell B4 is a dropdown of numbers: If number is less than 12 than cell I4 will be grayed out, & be locked. And if number is greater than 12 than cell I4 will be unlocked I guess I have to do...

Hi all, First time poster - would appreciate your help. I'm comfortable with using Excel but I would like to commit more time into learning it from first principles. Could someone guide me to a syllabus for - Basic - Intermediate - Expert. I know there is a MS Specialist Certificate but...

Hi I am trying to run macro as per the instruction below. It did not work. I opened the module and click inside and then press f5 but did not work. but if I go to menu run-->run, it will work, also if i click on run icon > , it will work. What could be the issue? thank you ++++ Run a macro...