existing

Hello, How would one go about running a specific macro for each items in a list? Also, items in said list need to be used as a search criterion in an existing form so the value needs to be input as a search value in a specific cell, in order for the existing macro to run smoothly. Would...

Hi everyone, Can someone show me the code to rename the files in a folder? Renaming is simply adding a fixed text string "IMG_" to the existing filename. It should replace the existing file (in the same folder). Thanks

Can i run my macro in every new workbook. or in already existing workbook. Can any body help in personalize? Thankyou

I want to connect to workbooks a hyperlink from one cell to another cell in a different existing workbook

So I'm having an issue with a countifs formula. I've got the formula to work but there's one more criteria that I cannot figure out how to account for. My current formula is as follows: =COUNTIFS(Data!BC:BC,0,Data!I:I,"Closed")+COUNTIFS(Data!BC:BC,0,Data!I:I,"HM...

I need to find a number that is not existing. My document is huge and I want to put in a number and it will give me a new code that isn't being used Column A is the section that the existing code is on B2 is where I want to put in a number. c3 is where I want to see what is the next available...

I'm posting on behalf of my boss. He recently upgraded to 365, because his 2010 version didn't have some of the formulas that I use in my spreadsheets. Starting last night, clicking on existing Excel files will simply open up a blank Excel without any worksheets active. He then has to go to the...

Hi All I'm after a bit of advice please. I expect someone has done this before. I have a list of 1000's of unique numbers between 1 and 6 digits that I want to increase all of to 8 digits. The problem is that I cant keep the existing numbers in the same order as they would be easy to guess...

Hello, I have been searching the internet from help, but am still stuck. I need to start updating an existing sharepoint list from a new access database. I have set up access with the correct column names, for the fields i need populating in the sharepoint list. I have tried using the move...

I have a excel file with about 1000 Rows and a single column, each cell contains a similar example: Cell A1 (INSPECTION RESULT: /(1)FACE "AA" GALLED, EXCEED EM LIMIT (0.010" MAX.). /( EXISTING: UP TO 0.037" APPROX. /(2)FACE "AD" GALLED, EXCEED EM LIMIT (0.010" MAX.). /( EXISTING: UP TO 0.030"...

I need the masters help on this! I want to automate our team attendance. I have J5:J14 in my sheet where I want to copy and paste to the SharePoint's existing list. There are 5 columns on the SharePoint's existing list and only 2 columns will be filled out.

Hello, I'm using VBA to add a table to a sheet but when I do so, it doesn't clear any existing formatting when applying my style. If you add the table manually, you can right click on the style and select 'Apply and Clear Formatting'. I've tried using the recorder to see what I get but it only...

Hi all, I am having some troubles when it comes to create a macro to export data to an already existing file. I have a file which will be changed every day (soruce file) and another one which I want to use as an archive (final destination file). Can any of you give me soem hints? I am...

Good day, I'm trying to match the value of 2 cells from one sheet to 2 column in another sheet. I can get to work with only one data but not both. The main point is to be able to look up previously entered information and avoid duplicate. here is the code i'm using to find duplicate. Set...

I have a macro which works fine but needs final touch........... at end of macro I need to do two things: 1. Copy the existing workbook as a tab delimited (txt) workbook in a different folder with a different file name. 2. Save the existing workbook (xls) in the current file path - simply...

I have a criteria I need to add to both true and false sides of an existing IF formula. I want to add IF(N1="ZINC",REF!A6&REF!A4) When I try, it's unhappy with how I do it so evidently I haven't learned how to do it right yet. Basically, if N1 has Zinc appear in it, _Z needs to be added...

Looking to open a file as a new tab of an existing workbook. I'm going to loop it through all the files in a folder, but the part I'm having trouble with is getting the file to open in an existing workbook. These are HTML files that open fine in Excel, I just can't figure out how to get them to...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Good day everyone, I would like to insert a predefined set of values (cells, rows) into an existing table , with the location of the inserted values depending on the values of...

Hi, I've got an excel file with an existing sheets, Let's call this main file as "TASE.xlsx" There's this specific link (URL specified below), pressing on it will download an other excel file. I would like to have this new file from that link to be imported/inserted into a specific sheet of the...

Hi Team, Is there a way to update an existing date column in Power Query by means of adding or subtracting days? I can use the function Date.AddDays to create a new column to do this, but it'd be neater to change the existing column rather than having to create a new one. I've had a look...