builder

  1. M

    VBA or Expression Builder for using toggle button to open a page

    Hi newish to Access and am just starting to try to dabble in VBA, Macros, Expression Builders to make my database forms cleaner and more user friendly. I have tried searching several sites and have been unable to find anything helpful to guide me in how to write the VBA code or use Expression...
  2. corppunishment11

    Multiple if(or) or maybe I need if(and) Can I make this work?

    I've written nesting if(ands) but I'm wondering if I can have an If(or do what I want it to. I'm looking to have one formula look at a set cell position A2 on sheet 1 "Bob Builder" and then compare that to sheet3 A2:A1000. If it's "Bob Builder" then return the values in sheet3 B2:B1000. But I...
  3. A

    Transfering Data from two different sheets

    Ok so I am not an expert at excel, but I know basics on how to pull from different sheets. That being said my issue is: I have Sheet 1 (Builder List) that contains all the builders that I work with, I have an empty column that is labeled "Total YTD Price". I want to transfer data from Sheet...
  4. A

    Transfering Data from two different sheets

    Ok so I am not an expert at excel, but I know basics on how to pull from different sheets. That being said my issue is: I have Sheet 1 (Builder List) that contains all the builders that I work with, you will notice there is an empty column that is labeled "Total YTD Price". I want to transfer...
  5. G

    Paydate column using Builder

    Hello I'm trying to use Builder to create a column in my table that lists the Paydate based of the week. Week of 09/17/2017 is paydate 10/06/2017 Week of 09/24/2017 is paydate 10/06/2017 Week of 10/1/2017 is paydate 10/20/2017 Week of 10/8/2017 is paydate 10/20/2017 The formula below is...
    • GMLee
    • Thread
    • 10/06/2017 10/20/2017 builder paydate week
    • Replies: 9
    • Forum: Microsoft Access
  6. W

    Using a VLOOKUP result as criteria in a COUNTIF/S formula

    Hi there, long time reader, first time poster. I've been searching all morning for an answer and haven't had much success. I'd like to shorten the below formula by using the vlookup result as the criteria in the countif/s formulas. The idea (apart from shorten the formula) is to add...
  7. S

    date calculation formula builder

    I've searched for info & studied what I could find, but not had much luck. From my latest finds, it seems there are many of us that can't get a grip on calculating with dates. Is there a, for a lack of better term, date formula builder, out there (click on the boxes, or ...), or anyone with the...

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