account

In column A, I have strategically placed the value of x in specific rows. I use a macro that goes to column A and then executes selection.end(xldown).Select a certain number of times depending on which row I want it to land on. For example if I want it to select the third row with an x I use...

Apologies for the generic subject - I didn't know how to sum this one up in a few words. I have a workbook with 2 sheets - 'Sales' and 'Lookup'. The sales sheet is an output from our sales database - the columns of interest are column D (Account Name), Column I (Description), and Column AI...

Hi all I have file data.xlsm with 03 sheets("result","balance01","balance02") Now I want macro VBA to check value each account number in row i sheet(balance01).column(B,C) with the same account number in row j sheets(balance02).column(F,G) If the same account but value(Bi) <> value (Fj) or...

Hello! I am having a hard time doing this in excel, and variations of it::confused: how can i calculate the monthly price i need to pay to pay down 2 accounts 2 0 where the 1st account is worth 2000 and has 0 percent interest and the 2nd account is work 10,000 and has 5 percent compounting...

I am try to cross reference 2 sheets -- 1 tab will have a Column of Account numbers (data) -- the other tab (TRECS) may have the account number within a sequence of other information (description) -- if account number is found I want it to bring all the info from cell it was found in...

Hi Everyone, I am no VBA expert and appreciate any help you can provide. I would like to learn how to search for a before and after instance to copy and paste information in between those two instances. And then repeat the process. This helps to create a format usable for a pivot table. For...

Hi, is it possible to simply update an existing power query with no knowledge of how they work? I have a calculation file which I inherited and want to update it to account for the current year and am a complete novice when it comes to power queries and power pivots. Currently, I have added...

I have a table of data on a worksheet that I add to continually. Column A is a list of account numbers that each have a corresponding tab or worksheet within the same workbook. Is there a way to format column A so that when I paste the weeks data into the table the account numbers will...

I want to get an accumulating sum of rows in the balance column where, in this case, the account number is the same. For example, <tbody> Day Account Dr Cr Balance 1 1000 100 75 ? (25) 1 1000 500 260 ? (265) 4 1150 400 100 <tbody> ? (300) </tbody> 5 1150 800 600 <tbody> ? (500)...

Currently, I am doing a report which contains lots of data and I need to filter out each unique account and copy& paste the data to a new/current tab. Looking to see if someone can help me on this. I will be very appreciate. What I want the code is to help me to filter each unique account...

I envision a summary as such: <colgroup><col><col span="3"></colgroup><tbody> Seller GAP MBP BOTH John Veronica Diana Kevin </tbody> Raw data is as follows: <colgroup><col><col><col></colgroup><tbody> Seller Account number Product Kevin 123 GAP Veronica...

Hi there ;) I hope you can help me with the following thing I'm (unsuccessfully) dealing with. I'm updating on a daily basis a report with a list of values based on a date, values which I want to sum for a given time frame, though only if they match certain criteria (with other words, the sum...

Hello, I am working on a macro that identifies the username, asks for the account password and sends out an email from Gmail. I tested it using my personal gmail account and worked like a charm with the default settings smtp.gmail.com and port 25. However, I couldn't manage to make it work...

Hi there looking to count all values that are of the same account as well as same names and then rank them by balance. I believe this is a two step process but I can not figure out how to get started. In column D I have the account numbers In column H I have names In column R I have balances...

Hello All, I am working on a project that has a summary sheet with some finance categories (see sample data below) using a matrix I have defined what Cost Centers and G/L Accounts​ are used to calculate the categories total. This is simple to do on a 1 cost center & 1 G/L Account basis using...

Good Morning I wonder if anyone could help me - I have a problem using Match. I have a database extract where by account number and account name are concatenated on the extracted report - this is OK because the account number is always 7 characters(always numerical) long and to the left - so I...

I have two columns, on the first 1000 customer numbers and in the second an account number. About 500 customers have multiple account numbers. I want to reduce the lines. I want only one line per customer number and in column two a string of the corresponding account numbers delimited by the &...

Hi all, i spent a good portion of the day trying to figure this out without any success. I created a macro that uses a system generated report to sort data and transfer it to a separate sheet. The thing is, the report is generated every day with sheet name as "Ledger Account Detail_20190415_"...

This sounds like it should be simple, but I am struggling. Thank you in advance I have 2 columns of data similar to the below (but 44,000 rows). First column is an account number, second is an identifier. I need to identify the where an account number has both a 2 and 1...

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...