empty row

  1. K

    Rearrange / Transpose data, cases dividend by white row

    Hi all, I’m kind of a excel newbie so I tried to get the answer by searching the web but I can’t figure it out. I have a question regarding transposing my data. Al my data is vertical like this: Every case is separated by an empty row. I want to pivot the data per case. That it looks like...
  2. F

    Find first empty row and copy/paste data

    Looked around and tried to modify existing code but without success. I have a workbook with a command button. When i press the button i want to copy the data and paste it in another workbook. But it has to be on the first available empty row, so that i dont destroy the old data. So far the...
  3. S

    Finding next TRULY empty row - VBA

    Hello, I've recently been attempting to get the next completely empty row in order to add data to it. Normally this would be pretty straight-forward, however I'm running into an issue where if the last row contains values that AREN'T in the cell on column A, then it will overwrite the last line...
  4. V

    How to code for search, previous, next, update, delete, print command buttons in user form in excel vba

    Dear Sir, I am newly learning the creating of user forms in excel VBA. For my office filing system, I have created a user form for incoming correspondence in SHEET1 to input data into SHEET2 in the same workbook. Userform have command buttons namely CLEAR, ADD, UPDATE, SEARCH, PREVIOUS, NEXT...
  5. sunyem

    Script works depending on size of table

    Hello Everyone, I have encountered some strange phenomenon when running a macro. So it uses the following formula to select the first empty cell in column B on a given sheet (which is activated earlier in the script): Freecell = Range("B2:B" &...
  6. smide

    VBA - paste only non empty cells from multiple sheets in the next empty row on a different/master sheet

    Hello. In Sheet1,2,3,4 and Sheet5 of my Workbook I have a data stored in column C (on all sheets). I need to copy only non empty cells from all sheet's (column C) into column D of my master sheet (Sheet6) in the next empty row eg. without empty cells. All those five sheets (as well as master...
  7. P

    Edit VBA Code to Paste Data in 1st empty row

    Hello Experts - The following code copies and pastes data between workbook sheets. Can someone please modify so it pastes in the first empty row? It currently pastes in the 2nd row. Set zDest1 = sht01.Cells(2, 1) zSource.Sheets(4).[a1].CurrentRegion.Offset(2).Copy zDest1 Set zDest1 =...
  8. D

    VBA - Open workbook and import data to next empty row

    Hi, I am relatively new to the VBA world and would much appreciate some assistance with the following. A project currently being worked on requires a macro to do the following: Open excel file from "Open file" dialog box Find data in specific ranges Copy data to next empty row of original...
  9. L

    VBA paste values into last empty row of a table

    On the tab "Instructions" I would like to have a module button. When you click the module button, I would like the following to happen on the tab called "LPA Database Scores Raw Data": There are two scenarios: First scenario: If F5 = "1" on the "Instructions" tab Copy B126:BO126 Paste as...
  10. D

    Select Range Until First Empty Row And Column

    I'm looking for some assistance in being able to automatically select a range based on when the first empty row and first empty column are detected. I've read up on Range.End, but that seems like its detecting for the very last row/column which doesn't account for an empty row or column in the...
  11. J

    Finding empty cells in a Row and doing something when found

    Hello - i would appreciate some help with finding empty cells in a row and then doing something when found. My code for testing is: Sub TEST_Find_EmptyRows_DeleteRow() Application.ScreenUpdating = False Dim r as Long Lastrow = Cells(Rows.Count, "A").End(xlUp).Row For r = 1 To Lastrow If...
  12. J

    check if two cells in the same row are empty, then hide row

    hello - originally i was trying to see if all cells in a row were empty then hide that row, but I was getting nowhere. Now I am trying to check just two cells, "A" and "E," and if they are empty then hide that row. here is what I have: Sub hideBLANKRows() Application.ScreenUpdating = False Dim...
  13. F

    Upsetting issue concerning "Blank Row Deletion"

    Hello everyone, I am working on an Excel file with numerical data, of 2825 rows total. Every about two data rows, there is a blank row, and every about 50 rows, there is a total row. What I need to do, is to remove the totals and blank rows so I can couple this file with 18 others that range...
  14. C

    Take data from one workbook and put it into next empty row, which contains drop down menus

    Greetings! A VB novice but I almost have it figured out except when I run the following code on "2014 Incident Reporting Form.xlsm" to transfer datat to "2014 Injury Dashboard.xlsm". It seems to ingnore any cells in the dashboard file that have data validation with drop down boxes and posts to...
  15. S

    Next Empty Row

    I have used code like this Range("A65536").End(xlUp)(2, 1) = txtrelief.Text before to find the next empty row and have a text box from a form print to that row. This time though I am having some problems. Whatever I type in the text box on the form lets say I type in JimJones it enters the...
  16. E

    Write Data to Empty Row with a Twist

    I have no training as will quickly become evident... Using Excel 2007: I have a userform with a ComboBox where if "(Other)" is selected the user must add a new contractor (name & address) to a worksheet and the name will then get transferred to yet another worksheet. When "(Other)" is NOT...
  17. J

    If there's not an ampersand, I want cell to be empty - it gives me #VALUE! instead

    Hey all, This is pretty much complete. The only issue I'm having is that if there's not ampersand, then just make the cell empty. Rather, it gives me VALUE error: =LEFT(A1,IF(ISERROR(FIND("&",A1,1)),"",FIND("&",A1,1)-1)) It doesn't like "" for some reason. Any other way to make the cell...

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