Hi. I have a sheet titled "Combined" with data beginning in column B. I've been trying to come up with a macro that would add a validation list to cell A2 and then copy it down only to those rows that have data in column B. I can't get it to copy down, unfortunately. Below is the little code...
I would like a macro to search a column (F2 down to the end), find a collections of strings that I will hard code into the macro and covert the strings to another string and paste them next to association string in another column.
If we start with D2 and search down for R.N, R.N. VA, and RN CA...
Hello - I have a spreadsheet where column A is a paragraph of text such as:
sent to: abc@xyx.com
received from: 1234@myco.com
Text here....
or sometimes the cell has contents such as:
sent to: xxx@ourcompanycom received from: xxx@mail.com Hello, I am looking for.. and so on.
Looking for...
I'm trying to write a macro and I'm having a little trouble. This is the data I have. It starts out with a reading number in B2 followed by a depth in B3, then a reading number in B4, depth in B5, etc.
Easting Northing
976 2,277,532.23...
I want to do a loop where you can copy say A3 worksheet 1 then add another sheet naming the work sheet "A3" then copying A3 worksheet 1 to A1 "A3". After that looping to A4 to a new work sheet naming the work sheet "A4"copying the value to A1 "A4", etc...
Is there a simply way of doing this...
hello good people,
please help me. my problem is:
Let´s say sheet - "delivery" - has a row1 that includes all possible delivery days. So A1 is 1.9.2013, B1 is 15.9.2013, C1 is 1.10.2013 and so on.
I want to make a macro, that will gradually go through whole row 3 in sheet "delivery" and look...
Good afternoon,
I am struggling to understand arrays. I have read many articles in this forum and in others but I can't seem to get a handle on them.
What I am trying to do seems simple.
I have 3 sheets, sheet 1 has a week column 4 data points columns, sheet 2 and 3 have charts.
I need...
Dear forum users,
I have a large data set in excel; 184 rows per column and roughly 569 columns. I want to copy the cells from column C and paste these below the values in column B with no gap. I then wish to copy cells from column D and place them below the column C values in Column B. I am...
Hello! I'm a little bit frustrated because this macro is not working. Good thing is that I'm not receiving an error message but it is not working.
I need to change the cell value of the information of Sheet 1 to the cell value of a conversion table at Sheet 2.
Sub ChangeName()
Dim h As...
Hey, guys, I am a complete spreadsheet newb, but as i've just started my own business i have been thrown into the spreadsheet gauntlet.
I have a manufacturer product list on spreadsheet with everything the manufacturer produces. I am only interested in certain products called "Eco-Nique...
I am searching for data which I just entered via INPUTBOX.
Searches for Data within Range(G7 and CA10000)
If the data is found then it copies that cellrow and range of Columns H thru K and Column S and Columns AC thru BZ into a diff. Worksheet or Workbook (Haven't Decided).
If this data...
Hey everyone,
I am new to visual basic and I have been trying to figure something out for a while now. Pretty much, I need to create a macro in excel that will search a different excel file for anything that matches a certain criteria, copies whatever the value is in the column c, and paste it...
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.