account

Hi everyone, I'm trying to design an expense form on Sheet 2 and I have 4 types of expenses in a drop down list in merged cells F-G17 with "categories" of Office, Executive, Meeting, Conference. What I would like to do is once they choose the "category" of their expenses, merged cells I-O17...

I have a large spreadsheet (to ER3500) and need to count specific columns with non-blank cells across the rows. I have tried several CountIf and CountIfs, but I can't get there. A sample spreadsheet is below. I want the total number of rows which have data in the Account, Color, and Response...

Hi all, I want to run a query which identifies the number of transactions conducted per account per hour and the amount. my table have 3 columns A: Account Number B: Transaction date & time C: Transaction Amount I have searched the forum q's but didn't see anything relevant so far. So...

Hello, I have a spreadsheet that is concatenating multiple ranges of data to formula a note that can be copied and pasted elsewhere. Unfortunately I can't figure out how to exclude blank cells and instead I'm getting 0's in my final note, like this: <tbody> #D9D9D9[/URL] , colspan: 2"]...

Hi, I’m hoping someone could help me with the tasks below; I know it’s a lot but Any help would be much appreciated. (#1-8 order matters) 1) in column AA SheetA any “0” change to blank cell 2) column AC SheetA some cells say “Fired - xxxx” , I’d like to change anything that doesn’t start with...

Hi, I have an idea about how I want my spreadsheet to work but I'm just not sure about the best way to go about it. As I will be arranging large volumes of data, I would like to keep it as simple as possible and avoid too many IF Statements which can cause the file to get too big. Can you...

I am trying to determine the best way to setup my workbook and i keep going back and forth between pivot tables, VBA, and Power Query and can't figure out what is right. I have a data file with a large number of transactions and i want to have separate tabs display a subset of those transactions...

I have copied the Excel online file link and paste and it says do not have Access. The first time it ask me to supply Organization Account password and I carelessly cancelled and now that prompt never appear again. I have the organizational Account password. What can I do ? Now it does not ask...

Hello everyone, This is my first time posting on here, and I'm very new to Excel VBA code, so I would appreciate some help. I have an Excel workbook with 7 sheets. The 1st one is a reference sheet titled Allocation, where I type in names of accounts into cells A3:A5. For the purpose of this...

I've created a filter for an account #, if that account # appears in my data file, I want to delete the entire row. This has worked before, but now I'm getting a debug error lRow = ActiveSheet.Range("A500").End(xlUp).RowIf AutoFilterMode = True And FilterMode = True Then...

Hi, what formula can I use for the data below, wan to find Sage ID and Account reference and get the amount $ for it. here is the data: <tbody> SAGE ID Type Account Reference Gross 100016 NorthwesTel 8327204 5794.25 100016 NorthwesTel 8327205 7705.03 100016 NorthwesTel 8335419...

sorry if this has been covered. I'm trying to move rows that an inventory item has sold to my sold sheet in the same workbook if I enter the account number in column Q. I want the account number to be able to move with it when it's entered.

I have a template for journal entries that I need to get into a different format. Right now I'm writing formulas that are working, but I cannot drag down so I'm thinking there might be a vba solution. There are 6 columns, B:G, account, center, debit, credit, company, plant. account and center...

I've searched this forum and asked Google but can't find what I need. I have a file with a Trial Balance - 6 columns wide by X number of rows long. The number of rows are dependent on the the accounts utilized that month. Column a contains an account number in "General" format I need a code...

Hi all, Can anyone help me out as I'm doing this one by one and there must be a faster way that I'm not aware of. I have a workbook of 28 pages. One tab is referenced by the month as in Jan-Wrk and its partner tab is Jan-Financial. In the work book, I created a general ledger with a...

I want to bring transactions of specific account 10001 from GL dump need help please. I have 25 columns which all I needed, given below 5 as sample GL dump Date | account| Description | amount | remarks 01/01/19 | 10001 | expense | 100 | ABC 02/01/19 | 10002 | income | 200 | CDE 03/02/19 |...

Dear All, I could like to use INDEX MATCH function to obtain a specific data that i need from Raw Data. How can i implement the formula? Please refer to example below. Thank you all. Raw Data (Sheet 1):- <colgroup><col span="3"></colgroup><tbody> Master Account# Buyer Account Seller Account...

Hi. I'm trying to create a spreadsheet to help keep track of bills. I'd like the spreadsheet to calculate how much money I'll have left after paying bills per month. Example: <tbody> A B C D E 1 Checking account #1 balance $10000.00 Water bill $100.00 2 Minimum balance $1500.00 Gas...

I have many account numbers in column A but if account 501000 & 511000 comes then text required in Cell B1 is "Good" else blank. I only know formula as follows, how to add 511000 also in the formula ? =If($A$1:$A$1000="501000","Good","")

OK here the thing. I have created a sheet for my work that shows financial data. But this data I only want visible based on several conditions( possibilities) To make matters more complicated more than one condition can occur. Also These conditions are triggered by cell value based on a...