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...
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...
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...
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...
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" &...
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...
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 =...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 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.