business

I have a column in one of my Access queries called CustomerName_DBAName. Below is an example of what that data typically looks like. CustomerName_DBAName JOHN T. PUBLIC JAKE A. SMITH JR. ABC COMPANY STEVE JONES - DBA: SUPER STORE BIG COMMUNICATIONS, LLC SOME BUSINESS INC. JOE SLOW - DBA...

the title says it all

Hi Guys, I want to update Vlookup range in the report with respect to sheet name in cell A27. <tbody> <tbody> Business Solution </tbody> Connect Status <tbody> Business Retail </tbody> =VLOOKUP($B$11,Oct!C:J,4,0) <tbody> Business Digital </tbody> =VLOOKUP($B$11,Oct!C:J,6,0)...

Hello, I am trying to create a work-back schedule where you enter a launch date/time and the delivery dates of that project are calculated based on hours working backward from that launch date. The working hours should only be business days and hours (M-F, non-holidays, 9am-5pm). The formulas...

I have a workbook that has 400+ business names with 20 to 30 products each, I really need to add business names to another column, Column a (business name) Column b(product name) Column c (hopefully business address) Am I stuck with copy and paste?

Good day everybody, I am facing a relatively trivial problem, but somehow I can not continue. Aussprache lernen I would like to know how (dax measure) many working days are still available in the current business month from today (in Excel/ Power Pivot). I have the following table...

Hi i'm using 365 I sort a remember that in older versions of excel, I was able to change the A,B,C, and the 1,2,3,to inches. Was I dreaming? I'm trying to make a business card and i don't want to keep changing the fonts and printing them till i get the size right. mike

For instance, I have a whole range of job roles and the count, and I want to group several functions together, such as: Group 1 Sales Marketing Business BD Business Development Group 2 Admin Administrative Accounts how do I filter and group them together easily as long as the job role...

I'm new to this site and couldn't find anything regarding any type of personal/face to face consulting or training services. Does anyone know if this is something that's offered and if so what/who is best person to contact? I work for a small business (10-15 people) in Eastern NC and we could...

I have generated thousands of lines of software using macro 4.2 in Excel V5. This is business and accounting software and was produced on a G3 Mac. I have transferred it to G4, G5, Power Mac and (the latest) iMac. I have also generated other software in macro 4 which runs successfully on all...

Hello, I have a set of data which I am trying time series. Can anyone help me with the vba code? The current macro creates the first event with the last business date but I want it to replicate the lines below but only update the dates current date. If last business day is Friday and I am...

Hey Guys, New to the forum, but I have something tricky that I want to do in excel. I want to generate a part number based off a specific word input. For example <tbody> Titus 350FS 22 22 24x24 Lay In Std White No Screw Holes None None None None </tbody> = <tbody>...

Hi I've downloaded some data which comprises of business name, address and post/zip code. The data has arrived in a single column but I now need to sort so that I can effectively swivel the company data 90 degrees so each business lists across a row. Not all of the data is consistent as some...

Hello, I am trying to create a dual axis chart; a bar graph of total calls with a line representing percent of calls that are during business hours. My source data is a list of calls that have the following information: session ID, duration minutes, business hours?(y/n), and OS type. My thoughts...

What would be the appropriate formula to extract the text between the 1st and 2nd underscores? Text: STR_UAT_19.3_MWaaS: MODIFY_EXISTING_INTERFACE - Business processing area is not populating when MFTP-ID is entered. * Original Value located in Column: F

I have a Programme Roadmap table with the following: Column B (row 4) - Business Unit Column C (row 4) - Business Area Column D (row 4) - Technology Columns E to AZ (row 5) are week ending dates The cell values are as follows: 1. GL (Go-live) 2. PLT-C (Pilot Complete) 3. REQ-C (Requirements...

I am using Office 365 Business and my Excel file is on OneDrive. I want to share it to another staff but I do not want auto email sent to him. Is this possible Thanks

Hi, I have a list of business names in Excel starting in cell A2 going down to A3, A4 etc. The record-set is pretty large as it contains over 100,000 rows. What I need to do is to retrieve the address for these business using IE and return the corresponding address in cell B2, B3 etc.. I'm...

Hi, I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example: In Category 1, Customer A had growth of 2% in the market but our business...

Hi Gurus, I need some help with an excel workbook I have. I have a worksheet that is auto filtered for all columns, in column I is a list of business names, 2000 or more and growing. I would like to write a macro that "deselects" certain business names in column I from showing. What is a...