account

I have never created a macro in excel, and last night I was trying to and I created an IfBold Macro by reading on this website, however it did not really do I really needed to do. I would really appreciate any help I can get. I am this General Ledger Activity report that I need to convert to a...

Hi there I am hoping for your help in creating a macro that will automate a repetitive piece of work I am doing I have a sheet with data in column A and B, both having headers. Column A contains a name and be B has a reference to an account. Some have references to multiple accounts and are...

Hello everyone, I expect this will be something that is very simple, but I am in a pinch and need a resolution to this without me researching. I have a file in column A (ID) I have an account code and each account has multiple ratings Column D. I want to quickly find and select the rows that...

Hi, I receive around 300 files through a software that i use in my office. The problem is that the software saves the files on my computer with the weird name which is meaning less. I would like to save those files with the account number which is located in each file in specific cell (different...

Hi Experts, I have nearly 1000 account numbers In Column A and accountdescription of those in column B, Every day I get the 100of Account number in mail and some accounts are reputative Ihave to update account number in Column A search the description incolumn B and update the same Is it...

Hello everyone, Pretty much new here and in VBA. I am working on a internship project that just consumes too much of my time (please dont think I am trying to escape the task which I don't I am just looking for a better and efficient way of doing this monthly routine). On a monthly basis I get...

Hello, Sorry if this seems like a stupid question, but I've been searching online and can't find any reference to this issue. I was recently setup with a new VM by my company. The version of Excel I have on the VM is the same as the version I had on my laptop and desktop machines (Excel...

In column A I have an amount (ie Cell A1 £100) In Column B I have a percentage (ie Cell B1 100%) In Column C I have + or - In Column D I would like the result so, for example =A1*(1+B2) This works fine if I just want a value added, but I want it to take into account whether it is a minus or plus...

Hello, I have a list of postcodes and wish to only count each individual postcode once and not take into account the amount it appears. Any help would be great.

hi, was wondering if someone could help. this is probably simple but has my head a bit messed. basically i want to do a formula where if the values of two cells dont match something then sum 3 cells to give a total. in one column i have account. and in the other i have department. i want the...

I've written VBA that reads emails when they arrive on my PC at home, extracts relevant details, looks up necessary info and saves or updates records in an Excel sheet. This enables me to leave my PC running and have it automatically load new orders while I am on the road. Because two of us...

I have an invoice table with all the invoices for all the accounts. Each invoice belongs to an account. We log the Invoice Date for each invoice. Each account should have 1 invoice per month. I want to make another table where all the account numbers are listed, and the second column would be...

I have three worksheets: Invoices, Accounts, Groups The hierarchy works like this - Each Group (row) can have multiple accounts That means that in accounts there's a column specifying group for each row. Each Account (Row) can have multiple Invoices. in the same way, in Invoices there's...

I've been hunting around google and forums trying to figure this out out using a formula vs VBA. I'm using google sheets currently for this. ColA - Account ID / ColB - Customer Name / ColC Customer sub accounts (ranges from 1-15 separate names) Another sheet contains all the customer record...

I have this code here and when I call the InputBox only the admin will match. All the others return the else statement. So I used that UCase but still. What is it that I am missing? Option Explicit Private UName As Variant, TheAccount As Variant Sub ActiveInactive () TheAccount =...

Hi, I have some repeated data from my database. Is it possible to make it in one row using macro. For example, for same data user, date login & remarks will loop at next column instead of next row. Could anyone assist me. Current data <tbody> firstname lastname id datelogin remarks tom...

Hi, Hope I'm asking this in the right place! I'm using Web Intelligence Rich Client. I have lots of account number that can have many Contract types assigned to it. I want to list all the account that DONT have "With Maintenace" logged against it (but could have various others). I have...

I will have an excel spreadsheet which will have a column for recipients, a column with their address, a column with their account number and a code for a specific text that I would want in the body of the letter. The end results that I'm going for is that based on the letter code that is...

Hi I have a macro which emails a report out to users based upon various details which is working as expected. The one issue I have is that I would like to be able to select a value in a cell that is the email address the message is to be sent from. At present the email will always come from my...

I have a combobox list that I populate with Private Sub UserForm_Initialize() Me.ComboBox1.List = [Accounts].Columns("A:B").Value End Sub the combobox has 2 columns, with the first one being bound: which works wonders as It shows me the account number and the vendor it belongs to. some account...