leads

  1. A

    decimals to feet and inches with excel 2002

    =B1&"' "&TEXT(C1,"0 #/##")&CHAR(34) 34.6 leads to <tbody> 34' 6 49/71" </tbody> thanks all i have forgotten how to post the spreadsheet
  2. J

    Leads and Follow-up Tracking Spreadsheet

    Hey Guys, I see this tracking-template is unavailable for download now, wondering if anyone has one similar they use for tracking marketing leads and follow-ups. https://www.youtube.com/watch?v=8Qb9rjl4XmA&t=46s Thanks!
  3. L

    Macro Help - Moving Rows From One Sheet to Another

    Hey guys, I would love some help building a macro. I have a list of info in a sheet named "Active Leads". I want to be able to type "x" into the cell in column H on Active Leads and the entire row be moved to the next available row on another sheet named "Past Leads". Is that possible? Do you...
  4. A

    sumproduct based on criteria in other columns

    I have a sheet with the following: A: State B: Leads (every row has an create date) C: Product (A, B, or C) D: Purchased (0=No, 1=Yes) On another sheet I'm trying to create a chart with <tbody> Product Region Leads Customers 1 New England X Y 1 West 2 East 2 West </tbody>...
  5. A

    onedrive - live updates with restricted access?

    hi all. I have a central 'leads' excel sheet, that is stored on our onedrive. Person A through person D have access to it. I have another sheet "Output.xls" stored in the same location, where person E can access / see it, but not edit. output.xls is pretty much a selected data transfer from...
  6. D

    Excel Default Program

    Hi, My Excel has been updated to a newer version recently and some files are now showing up with a blank icon. These files were previously opened through excel and i was able to work with the documents. I have been through the open with which leads me to a window with the following name...
  7. T

    Data to populate from one WS to another based on data entered in a cell

    I have 2 worksheets; LEADS & SALES When any date is entered into LEADS H6:H1005, The information in LEADS B, C, D, E, F, & H6:1005 Will populate into SALES B, C, D, E, F & G6:1005 (The last column letter is different on LEADS vs SALES) I do not want the info to auto sort based on any dates. I...
  8. G

    Need help with countif and indirect.

    Hey all, I'm trying to build a sheet for my company that pulls information by month and then matches the agent name to countif and track total leads. I've setup seperate sheets for each month that log how many sales leads are generated and which agent submitted the lead. My goal is to create a...
  9. S

    Validating First Name and Last Name for Leads

    Hello, I have a huge list of leads and have the names segregated as First Name and Last Name. However, in some cases, the names have been switched. For e.g.: Some of the records have correctly placed the lead name 'John Smith' as John under First Name column and Smith under Last Name column...
  10. J

    leads and conversions data patterns

    Hello. This is a bit off topic of Excel other than I'm using the program, but I'm presuming a lot of people on here are in marketing and do similar things so looking for some advice. If anyone knows of a marketing / data forum where this stuff is commonly discussed please let me know as I could...

We've detected that you are using an adblocker.

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.
Go back
Back
Top