merchant

Hi hoping someone can help me. For some reason I cannot get the following to work. when the checkbox is ticked i.e. TRUE 1. unlock cell named "merchant" 2. clear merchant contents (a formula) 3. message box "Enter Merchant" (I've got this bit to work fine, where it falls apart is the...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height: 14.0px}</style>MrExcel gurus, I'm trying to improve a workbook that helps manage spending well enough that it justifies...

Hello, team! I've got a time-consuming task I'm trying to streamline. I have a spreadsheet with four pivot tables on one sheet, each pulling different information about the same Merchant. I filter by the Merchant field. This data comes from a large external database, and if I record a...

how can I add a calculated field wherein the calculation is the division of one column in the table by the count of another column in the table? For example, assume a two column table as follows: Merchant Installments The Pivot table has 3 columns: Merchant as the Row label count for merchant...

Here's what I want to do: I have a table in Excel with all the records I need. I want the user to select (filter) a pivot table for a particular merchant ID. The pivot table then populates with the summarized information for that ID, including states and counties where the merchant does...