so I have a spreadsheet that has 8 columns. In the first column is a date of 1st payment, the next column is amount of 1st payment, the third column is date of 2nd payment, four column is amount of 2nd payment, The fifth column is date of 3rd payment, six column is amount of 3rd payment, seven...
I'm a little stuck on a project.
Sheet 1 has a list of people
Sheet 2 has a list of people
Sheet 3 needs to compare the lists in Sheets 1 and 2 and list the differences between them.
I'm not sure of the syntax, and how to write the indirect formula to do this ?
Any help would be greatly...
Hi, I am fairly new to vba and I am trying to copy data from multiple sheets except from sheet names that are in the defaultsheetnames array.
DefaultSheetNames = Array("Admin", "QBBOM", "Index", "Master", "Template", "Revision Log", "Instructions", "Sample", "Deleted Items", "ChangeLog"...
Heyy there,
My problem is : i cant remove duplicate column by single string
I want script or marco or anythink (automation) to fix this problem
Take look of screenshot of my solution what i need
Thank you every one who fix that :D
Hi Guys,
Can someone please help me to correct my VBA code to achieve my requirement please.
I have a range of IP using which I want to create a command and I want to do this via macros.
The command part will be same every time, only part that will change is IP. So, I'm trying to achieve this...
I have the follow values in a cell:
Original Value
BlockChain
Retweet
BlockChain
BlockChain:xyz Retweet:abc BlockChain:adc
xyz
abc
adc
would like to use excel formula and VBA
how to make VBA copy every cell from a column to a different .bat file. The location and file name are in the excel. For Example:
A contain FileName
B contains location
C has the script for the Batch file
A & B are different values.
Please help
Hello,
I have 4 sheets in a workbook (Sheet1, Sheet2, Sheet3 and Sheet4)
On Sheet1 I have a dropdown in B1 to select from a list of fruits. For eg. Apple, Banana, Cantaloupe,
Below that dropdown there is a "Store" table with headers Store(A5), Isle(B5), Shelf(C5)
On sheets 2,3 and 4, I have...
Hello all,
This is a difficult question for me to phrase, but I can provide background:
I have 200 properties.
I have a Statement of Cash Flows with each property listed with hundreds of GL Codes and amounts.
I want to summarize the data in a new table by taking whatever GL Codes I want from...
Hi. My excel sheet looks like this with 100 projects. What I would like to do it
1. Search for Project code 1415
2. Copy all the rows from A21-A29 and paste it in Sheet 2
3. Next search for code 1414
4. Copy all the rows from A9-A20 and paste it in the next available row in Sheet 2
5. Next...
Hi, I would like to optimise my excel spreadsheet
Is there a scrips to in one Column according to the name selected from a drop down box an email would automatically be generated and sent to the relevant persons after saving the document (data changed, email trigger to the selected individuals)...
Good day, All
I am using this code to look for specific Like value in a column then copy it over to next sheet and then remove the row
but when it goes to copy the next row it skips a row and start but the row below
Please Help.
Much thanks in advance
Sub SearchString()
Dim c As Range
Dim...
Morning all,
Apologies, posting this because I could not find appropriate solutions to my problem. Earlier I obtained this particular code from Dante (which I’m immensely thankful for) which helped in generating a message box (when two conditions are met) for my worksheet:
Private Sub...
Hello,
I'm looking for help in locating and replacing/deleting the following pattern within a string in a cell:
"xxx.xxxxx.xxx.xxxxx.xxxxxxxxxxx" where x represents a numerical character
i just learned how to use regExp...but can't figure out for the life of me how to tell it to look for the...
Hi,
I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes.
The sort of thing I’m after...
I am looking to make a Macro in VBA that when run:
creates a new sheet called "results" after the first sheet (to the right)
on the original sheet search Colum B for if any of an array of words is present in a cell
if it is to select the row and move it to the sheet called results
delete the...
hi i need to find a way to create multiple txt files from an excel, as shown in the picture. In detail i need to create a file txt with the name "sez-A1" and another "sez-A2" and so on. inside the txt i need to have the numbers of the 2 columns x and y from the excel
Hello,
Context; I'm very much an amateur when it comes to excel but managed to put the below 2 formulas together from a few forums but its causing my s/s to run incredibly slow. The s/s is also web linked to an intranet form which could be causing some of the delay also.
The form is a...
Need to extract the values between the hyphen in Column "Values". No VBA please. Trying to use the search function built in. Not sure how to how to deal with the spaces.
Values
Car
Builder
Name
Location
Green Car - Ford - Aisha - Toronto - London
Green Car
Ford
Aisha
London
Red SUV -...
Good morning.
I found few post related to my question but none of the solutions worked for me (Maybe I did something wrong)
I have a long list (100') of webpages (https) and I need to update some of the content they may have.
So, I wanted a macro that takes all addresses from column A...
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.