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...
I'm having a difficult time writing a formula to copy the data into one worksheet from another worksheet.
My file has 3 worksheets: (1) Data, (2) Communications (3) Supply Chain
Data Worksheet: Cell B1: Communications
Data Worksheet: Cell B4: This should populate with line 2, cell A2 from the...
=INDEX('\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$A$2:$D$800,MATCH($N$17,'\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$E$2:$E$800,0),1)
Hi guys the formula above returns the value I'm looking for but I want to add...
Hi,
i have this huge spreasheet (attached) that i want to search for records and put the results temporary an new sheet but i am not good in vba, can any body help.
<tbody>
<tbody>
CARRIER
ACCOUNT NUMBER
ACCOUNT NAME
BTN
WTN
AUTH_CODE
AUTH.CODE.STATUS
BCTEL
000071411
CENTURY 21 MOVING...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.