next available cell

  1. evandrobp

    Check next row for new list

    Hello all, thanks in advance. I've tried tons of formulas and combinations but no success. It doesn't matter if I have to add the tab name for each section of the formula or if there's a way to get every tab's names without mention it in the formula. No VBA please (unfortunately). I'm trying...
  2. J

    Help needed, data input

    Hi all, was hoping someone could offer some advice/help. Trying to devise a way of logging payments using a simple userform. I was hoping to have individual sheets for individual jobs with a dropdown on the userform correlating to each sheet - hope is that user would have to select job...
  3. A

    VBA to loop through non-blank cells in column and return next value in a different cell?

    Hi everyone, I'm having trouble trying to find anything anywhere online that even does anything remotely similar to what I'm looking for so I can try to learn how to tweak it, but I can't figure out how to even get started on the script, let alone write it out in full. I'm not experienced with...
  4. A

    Code to copy from active worksheet to another workbook next available a cell

    I need to copy a range A1:D5000 from the active worksheet I have open and open up another workbook paste it to the next availble a cell and then save and close that other workbook. Please let me know if you have the VBA for this as I have tried multiple things to no avail. Thank you!
  5. W

    Insert a table on the next available row after a macro has run

    Hello, I have a spreadsheet that imports data from a HTMl file and tidys up the data via a macro, this data then needs manual inputs (reason codes) into a column. I have a command button than sorts the data by the manually inputted reason codes. I would like to know if there is a code that...
  6. T

    Repeating Data

    Hi, I'm new and just starting to learn VBA. I need help copying and repeating data underneath itself. I need to copy a block of data and repeat this data 13 times underneath itself. As the length of the data will change each month I cant get it to paste into specific cells as I want to to...
  7. H

    Unload Me interferes with vba

    I have the following macro which works perfect except... after selecting an item and loading it into the next available cell I need the userform to vanish, so I put the Unload Me at the end, without Unload Me the combobox puts the data in the nest available cell and stays on the screen , select...

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