keyed

  1. B

    Help with a macro please

    Hi Everyone, I have a worksheet where cell B2 is populated by a handheld scanner as text, cell C2 is a date that is keyed and cell D2 is an invoice that is keyed and formatted as text. What I am looking for is when B3 is populated, cells C3 and D3 are populated with the same date and invoice...
  2. I

    VBA code to auto-populate details for certain cells based on certain conditions

    Hi, I'm trying to figure out how to auto-populate details for certain cells based on certain conditions: Columns A, I, L, and Z should auto-populate Date when Column B has information keyed in Column F should auto-populate "Walk In" and Column G should auto-populate "Endorsed to" when Column...
  3. J

    Referring to a named range within a formula

    Hi, I'm using the following formula which works fine. "_1" is the name of the array being referenced, and is also typed as a value in cell C4. =INDEX(_1,MATCH($A7,'1'!$A:$A,0),MATCH($C$3,'1'!$6:$6,0)) As I mentioned the array name "_1" is hard keyed into cell C4. The following, almost...

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