located

  1. H

    VBA Code To Copy Files From Path To Path

    Hello Friends, I need a VBA code to copy all files from a folder located at From Path to a folder located at To Path but only those files which are new or have a modification date other than the files which already exists in To Path. For example CASE # 1 There are 25 files in the folder...
  2. H

    Macro to print various PDF's from a folder

    Hi, I've searched the forums a bit and haven't found exactly what i'm looking for, so i'm wondering if anyone here can point me in the right direction. Background:Each quarter, members of my team need to print financial reports for different companies. Each company's files are located in a...
  3. kelly mort

    VBA select image from open dialogue box and rename selected image with content of a textbox

    The challenge gets tougher and I have to call on Tech support:) When I click on a command button, I want to access the open dialogue box where I select an image file from a folder - this could be anywhere on the computer. Then I rename that image with the content in textbox1 (for example)...
  4. H

    Move multiple files by vba

    my files are located in C:\Users\WolfieeeStyle\Desktop\Files i have to move 4 to 5 files(it can be more than this) from here C:\Users\WolfieeeStyle\Desktop\Files to C:\Users\WolfieeeStyle\Desktop condition-check wheather my files are located in C:\Users\WolfieeeStyle\Desktop\Files if yes then...
  5. H

    Add a Calculation by VBA

    Multiply the value of B2 by 1.5%, then multiply that result by 56 and then paste the result in D2(i need only result in the cell no formulas) note- 1st row contains headers so ignore the first row The file will be located in C:\Users\sk\Desktop and file name is sample.xlsx file is not opened so...
  6. H

    Addition by vba

    calculate and add all the data in column G and paste the result in K4(only the result not formula) note- 1st row contains headers so ignore the first row The file will be located in C:\Users\sk\Desktop and file name is sample.xlsx file is not opened so we have to open the file by vba and do the...
  7. E

    Conflict with

    This might be difficult to explain, but I'll give it a shot. Basic overview is a table where numerical scores are entered. The scores are ranked 1, 2, and 3 based on the "Div" (Division) and the Model of the car. DIV is located in A68 and Model is Located in A67. The code below is for...
  8. Nelson78

    String: how many characters could contain?

    Hello everybody. dim code as string I have a string composed by 1474 characters. When I define code = "..........................................." part of the string - located in the belove row - is red. I suspect a maximum length for the string variable. Isn't it?
  9. C

    Replace specific text with value from another cell

    Hello all, I’m trying to create a macro, but am having some difficulties. I am looking to search a cell (“K2”) for the word Location. Once found I would like to replace that word with the contents located in cell “L2”. This sheet will have many rows and the information within column L will...
  10. C

    ComboBox If then Statement for moving cell

    I am trying to have a spreadsheet enter the value of the NameTextBox into a cell if a selection in XYZComboBox is selected. However, when the code is run nothing happens. There are no errors indicated but still nothing appears in the selected box. The box that I would like the value to appear...
  11. Z

    How Do I Find the MEDIAN if my Formula Meets Certain Criteria in Excel

    Hello, Can anyone show me how to write a formula that will find the MEDIAN of a group of numbers in one column related to specific criteria in another column? My business segment name data is located in column T and my days open numbers are located in column U. Below is the formula I've...
  12. J

    finding Row number

    Is there a way to find a row number on sheet "1"where a name is located from a cell on sheet 2 example JOhn is located on sheet 1 on row 20 can we find the row number where john is located and enter it in a cell on sheet 2? <colgroup><col><col span="2"><col span="4"></colgroup><tbody>...
  13. G

    "GO TO" TODAY()----select today out of full year dates in one column.

    I have a rather large spreadsheet that has twenty col across and 430 rows down, 365 of these rows have information and a date starting with 1/1/2019 in D36 thru 12/31/2019 in D401. Top 5 rows are froze so they can view averages in Row 5 and other information. Also a place to put the buttons for...
  14. Trevor3007

    add number based on date

    hi, i know what i want it to do, but dont know if its viable I have to invoice the customer each week . So for example :- WC 11//2/19 has invoice number 9 is it possible to automate the invoice number (located in cell g1) to change accordingly based on the WC date (located in cell b4)? so...
  15. kelly mort

    Copy data when combobox value changes

    I have this challenge here with me and I need some high power brains help me pull it up. I am looking at column F because it contains items that are in my combobox. So when I change the value in the combobox, then verify if that item is located in column F. If it's located then no copy. If...
  16. K

    having trouble understanding how(why) its finding this one cell when using VLookup in a userform(?)

    I have a userform with a combobox to select names on a worksheet. The names and associated data is located in a named range (DynamicRange) Below are some screen shots and the code that I curerntly have: my userform showing where I am choosing the name "Aimes, Kelly" : and after I leave that...
  17. L

    Email alerts with an expire date

    I am looking for a way to receive e-mail alerts when an expiry date is approaching. This date would be located in a cell in excel. Would like to have 6 month, 3 month and 1 month warnings. Thank you!!!
  18. S

    Message box for user input to run macro on a range VBA

    Hello! I have a bit of code that manipulates data starting in a specific cell. Trying to figure out how to do this by asking the user to select the range, not matter where the table of data is located. The code I have now: Sub SplitDepthsFromSampleID() Dim ID As String ID =...
  19. S

    Is it possible to change the target cell's value (Value A)base on another value (Value X)entered?

    Can someone please help me on this or at least show me the link on how to get started? I am thinking of going paperless with check in and check out through excel + barcode scanner. So right now I have a master list of all the cases we have in the office. My idea is to first type in their...
  20. D

    Extract second to last number from string

    Hello, what formula could I use to extract the second to last and third to last numbers from the below string separately? I want to pull 4.410 out and then the 5.007 out. 704938 1-6/9" Dia. 12L14 Metal Row Hard 1 5.007 4.410 4.4330 the string is located in cell A10. I extracted the last...

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