located

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...

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...

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)...

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...

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...

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...

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...

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?

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...

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...

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...

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>...

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...

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...

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...

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...

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!!!

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

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...

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...