business

Thank you in advance. Do you know how to “easily” extract information into separate reports? I have a spreadsheet that has five columns and 200 rows. The column headers are: business name, first name, last name, userid, and phone number. I know about Data>Filter, but I’m imagining when we...

A - Client numbers (duplicates when applicable along different lines of business) K - fixed monthly number count per line of business The CAPS sheet is our monthly recurring revenue. I'm aiming to distribute that recurring monthly revenue across the (K) column IF A=duplicate paths. Having...

So my date formats are producing in a report like this: 43112 I was using the following to make that a short date: Range("DataTbl[New Business Month]").Selection.NumberFormat = "mm/dd/yyyy;@" I keep error-ing out though...

Hi Please Help me with this I have an Excel with Sheet named BUSINESS - which contains the complete Contact database of 258393 + Records and Email in Column K I have an another Sheet Named Bounced , This contains a list of 7000+ Emails that have bounced back . I wanna remove those Emails...

Hi :) I was wondering if someone could help me with a formula I am having a hard time coming up with: I have an excel sheet with various recipient addresses. The recipient name column, say column A, will look something similar to "Ship to business #1584" or "Ship to business #1224" or "Jane...

Hi Folks, Is there someone who has a daily inventory excel that I can use or make a pattern with? The business is for a small enterprise, needed to maintain the daily inventory. Thank you.

Okay so first of all I know this is a needlessly complicated solution. But my boss is a little demanding and wants what he wants. Anyway we have a weekly executive meeting and each member of senior management brings an agenda. Each agenda has old business (we'll call OB) and new business (NB)...

(cross post for: https://community.powerbi.com/t5/Desktop/Also-return-dates-when-sales-0-in-table-and-charts-cumulative/td-p/324639) Dear all, I have a 'sales' table and a 'dates' table. The dates table contains : - Date (from jan2016 until dec 2020) - month-day - month-workday - month -...

I have two pivot tables in two worksheets. The first one is controlled by a combo box in which the user selects a business ID. The information for that ID then appears in that worksheet's pivot table. The second pivot table has two combo boxes that are filled based on the user's selection in...

Good Morning Hope you can help. Have a column of 10,000 rows. The column is called Business Type This column is one field which is formulated in two ways. The first format one cell with each business class separated by a comma. Marine,Motor Fleet,Specie,Cyber,Hull,Cargo The second...

Good Morning Hope you can help. Formulae required for looking at multiple business classes and labelling them in another cell. I have a spreadsheet has about 10,000 rows. Each row has two fields Column A = Company Name Column B = Business Type Now the Column B is one field which is...

Hi Forum! I'm trying to copy all the values that are not found into column J. But get an error at the line Selection.Copy Destination:=Sheets(1).Range(lastrange).Paste Any ideas why? Option Explicit Sub codeforP() Dim lastrange As Long Dim lastrow1 As Long Dim lastrow2 As Long Dim business...

Hi, I am working on a macro wherein it should count the number of cells that meets the following 3 criteria: 1. Range N:N is > 5,000,000 2. Range AE = To prematch 3. Range J:J = next business day My current codes are as follows but I am not sure on how to integrate the 3 codes. The SD =...

Hi, I am working on a macro wherein the condition is If the values on the cells on column L is equal to the next business day(ie 02/11/2017) then Activecell.offset (0,5)value= "TO PREMATCH" Can you tell me the code for the next business day?

Hi all, how to filter last 5 business days from today’s date by using VBA, Note : already one column is filtered now I have to filter another column with condition last 5 business days from today’s date

Hi all, I have a form that before updating, I want to store the old value of one particular field. The original field is an integer, and I want to store the text description. My code looks like this: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim FormName As String Dim OldBusinessterm...

Hi, I have a ticketing system I run reports against and I am looking for a way to automatically populate a due date in excel by adding X number of business hours to the created date. X will depend on on a priority code. A sample date is <tbody> Created Work Hours Priority Code Due...

calculate business hours between two dates..including weekends and exclude holidays

Hello Mr. Excel members. I am turning to you for help and I hope I don't confuse you. SO, here is the situation. We have data that is appended to a spreadsheet daily and now we need to have a very simple count done, but it turns out to not be so simple. Here is a sample of the data: <tbody>...

hi there, i feel like this is simple but having trouble figuring it out. i basically want to pull data from one sheet to another where the data has to meet multiple criterias. the criterias are week#, year, and business unit if all of those criterias match on both sheets i want a return of...