filling cells

  1. K

    SMART Formule Like Vlookup Required Like AI

    Dear All, Please Help I receive daily 1000row of data with address merge together i have to search one by one to find particular word to the accurate address for the system to understand and the address which client gives is not accurate some merge,some with comma some without spaces. Is...
  2. M

    Fill in blank cells based off criteria

    Happy Friday everyone, I have 2 columns of data (A-Trans and B-Reason) - each trans in col A should should have a reason in col B. The logic I am trying to apply is: if A3<>A2 do nothing. if A3=A2 and B3 is blank, B3=B2 I am looking for a solution for this problem. I preferably am looking...
  3. P

    VBA code for the action of reading data and filling cells

    Dear all, I've been making a large Excel file with lots of data and formulas. Its supposed to be a system for a specific department. I've made a sort of loading screen/splash screen when starting up where it says please wait while the program is loading. then at the same time the workbook...
  4. likexl

    Fill empty cells in a row between two value containing cells

    Hello, How one can achive solution in the following situation: <tbody> ID STATUS DAY1 DAY2 Day3 Day4 DAy5 H1 PASSIVE 100 100 100 H2 ACTIVE 100 500 H1 ACTIVE 100 500 200 H3 ACTIVE 100 200 500 H4 ACTIVE 100 200 500 </tbody> After...
  5. R

    So infuriating!!! Placing values into cells works except for last row

    Hi I have a dataset from a relational database that I ma using Excel VBA to format from one worksheet to another I take the raw export data and depending on whether it's header or child record data I format it a certain way in the worksheet I've two worksheets 'Export' where the Database...
  6. S

    Only filling in cells that are directly below already-filled cells

    Let's say I have someone enter 4 numbers in the range A1:A4. This will look as follows: 1 2 3 4 I have these numbers automatically enter the cells in a separate row. For example, the numbers go into the range D4:G4 to look as follows: 1 2 3 4 Now here's the important part. Can I have 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