basic

All, Could you all help me figure out how to get this to converge. Or could someone get it to converge on their pc and help me with the options I need to change to get it to converge on my PC? I am wanting to set cell H28 to zero by changing the value in cell M10 . Based on basic math. I...

I would like to copy the values in the range of cells A1:A17 into a basic text box, called Textbox 2. Here is the code I am using: Sheet6.Shapes("Textbox 2").TextFrame.Characters.Text = Sheet6.Range("A1:A17").Value It keeps giving me an error of: Runtime error 13. Type mismatch.

I am new to the forum, and while I considered myself an expert in Excel, now that I have started working with Macros and VBA, I am a humble beginner again! What I'm trying to do is the follow... Look at all cells in range B2:B100 and if B2 contains X, then copy the contents of C2 and add it...

Hi all, I am trying to present some basic data in a more user friendly way. I have a basic set of data (4 columns and 72 rows) and I would like to add a slicer to this for selection without having to pivot the data. Is this possible? Thanks

Hi there, In cell C2 (green) I have the following basic formula =IF(C2<B2,C2,B2). I would like to add another argument that if no entry is put in cell B2, then cell A2 is returned instead of "0". Any assistance would be greatly recieved. Regards Ben <colgroup><col width="29" style="width...

I need to learn Vlookup and Pivots in a hurry! Any recommendations would be greatly appreciated. I’m just a basic user of Excel with not much function experience. Please help!

I'm new to the VBA world so I am unsure of even where to start with this one. What I have is a table with names and how far along those people are in there training in different areas. What I want to do is search that table for everyone who is training/basic in a certain area and copy their...

Hi Guys I'm no VBA coder but have used the 'Record Macro' tool to create a basic macro in my Personal Macro Workbook in Excel to tidy up some excel exports that are regularly dumped from one our doc management systems. The recorded script is as below. My basic question is this: I want to be able...

Hello everyone, Just a quick question, if I have knowledge of VBA in Excel could i be certain to say that i know Visual Basic ...not for applications. Are they literally both the same programming language? Don't know if this makes sense lol

Hi all, trying to help daughter with this basic excel formula to apply to all of column M =IF(K1>=L1,"Y","N") but I don't want to return a value where L1 is blank. I apologise for such a basic question, but have been searching & trying code from online without success and my daughter is...

I have been looking around for an answer for a few days now and I can't seem to find anything close to what I am looking for. I am hoping you guys can either tell me if it is doable or not! What I want to achieve is select a name from a drop down list and show me all the items associated with...

I created a new macro the other day and it was working fine. Today when I attempted to open it, i received the error "Can't find project or library" immediately when opening the sheet. I found the support on the microsoft website indicating to: Open your database. Press ALT+F11 to switch to...

Over the years I've been seeing the subject product increasing more and more in the MS office field. As I look through the features being offered off the Banner Ad here in Mr Excel - I do not see any reference or wording with regard to Visual Basic for Applications. Can someone clue me in on...

How to tell following criteria in if function Employees who are in grade 1 are subject to 1% of basic salary Emoloyees in grade 2 are subjected to 2% of basic salary Employees in grade 3 are subjected to 3% of basic salary Calculate the service cost for each vehicle using the “Logical IF”...

Essentially trying to figure out a formula or what function to use to figure how much what % will come out of a base amount, where the % rates are referenced from a separate table displaying value ranges and what % rates apply to them. https://imgur.com/gallery/tYKuK Its a pretty basic...

Hello, I'm having a lot of trouble with this one so hoping someone can help. I need a formula to sum a range of cells using the weighting below. I'd really appreciate any help with this. <tbody> 1 Needs Development 2 Basic 3 Intermediate 4 Advanced 5 Expert </tbody> <tbody> Total...

Hi can anyone recommend some good sites or books for a rookie to provide a basic understanding of VBA in Excel? Any hints gratefully appreciated! Ali

Hi, I have got 8 different types of components and each component has a quantity of up to 150 pieces. Each piece gets measured and marked with a serial number. I have a basic spreadsheet to capture the data (https://imgur.com/a/6xcAM). Pretty straightforward. with some conditional formatting to...

Hi, I need help with an IF formula to express the following : As example there are 6 levels and each level correspond to a range in spreadsheet : Column D Column E Column F 1 100 200 2 201 300 3...

Hi, I have a question regarding a potential solution and whether it may work or not. I have a basic webpage that collects basic information, i.e. Name, Make, Model. I can convert the data collected into a URI string - hoping to launch an Access Form where I can generate an invoice based on list...