Good morning from a very grey UK.
I'm having trouble getting my code to work, I'm trying to look in column M for the value "complete", then copy the entire row to another worksheet. Then, to look at column N for the value "complete" and copy the entire row to another worksheet. Then do the same...
Hi,
I am trying to unzip latest file and copy contents in it and paste in different Path/folder.
When I am using this code I am able to open the zip file which i mentioned and was able to paste it in destinationPath
ub UnzipAFile(zippedFileFullName As Variant, unzipToPath As Variant)
Dim...
Hi Gurus,
Good day!
Could you provide your insight on how the macro can paste the data from a worksheet to another with merge cells?
Workflow:
1. I have a main data worksheet and files to update. Files to update on this case is same with State provided in Source worksheet. All State data...
Hi
So, I have multiple workbooks (they are called: Human Resources, Science, Corporate Management, Public Affairs, .... I intend to add more). Each workbook has a sheet called: "Staffing-Processes". The data in each sheet has several rows (over 500 in some of them)
I would like to be able to...
Hi,
I have a sheet in a workbook that displays results based on a drop-down list in that sheet. For example, if you choose "Site 1" from the list it will show the data pertaining to "Site 1" in that sheet.
There are about 100 different options (100 different Sites) in the drop-down list.
I am...
Hello. I'm using this code, but can only seem to get it to work if I add a redundant column at the end of my dataset. In order to to that, I'm referencing column M, but in reality, I'd like to just be able to reference column H. I'm almost positive that it has to do with the offset and resize...
Hello,
What I am trying to achieve here is the following:
I have a column with filenames that includes the extension (in this case, .pdf) - these are plain values, not results of formulas
I'm trying to create a macro that loops through the column (that starts at B2), use the values on each row...
In the code below I am copying and pasting data from my pivot table into two other sheets. At the end of the process the pasted area remains selected on both sheets. How do I remove that selection and just have the cursor in say cell A1 or wherever I want to leave it on those two sheets? I...
hi,
I have 3 sheets in this attached file where I record information in the data sheet and it is saved in the Save_Data sheet.
In the Admin sheet, how can I write a formula that by entering the date and user name, the registered information from the Save_Data sheet will be called and placed in...
I'm completely stuck and needs help with some fresh code. Need to do.
1.- Copy numbers from sheet Data, to another sheet, for example sheet 14, only column C only 4 numbers that cell no has color
2.- Create macro for the rest 8 sheets.
Sub new1()
'declaring the worksheets, Sheet2 and Sheet3...
Hi All,
This is my first post so go easy on me, also let me know if I am posting wrong.
I found an old thread relating to this topic that included a code however there is one change that I would like to make and my coding knowledge isn't advanced enough to figure it out.
I am trying to have a...
Hi guys!
My name is Eduard and I am fairly new to VBA. I have a hard time finding a way to create a form that allows me to send values from an entry point to a "so called database". What I need exactly is a code that will allow me to copy
values from 2 cells to another 2 cells in another sheet...
Hello,
I have an Excel table that I update with new information each month. When new data is added (new rows), using VBA I enter a vlookup into the new rows and the correct data is retrieved. However, when I select the new rows and try to overwrite the vlookup formulas with values (Paste...
Hi
This may have already been asked so apologies if it has.
I have a spreadsheet which i need copy column A, B and column AV from 3 sheets and paste these into a new worksheet. I need to try and set this to happen automatically.
I think this will be a VBA before save (i think) is this...
Hello,
I am looking to write a macro that is able to copy values in rows 3 to 10 if the word "copy" is in Row 1. For example, if Copy was in A1 it would copy A2:A10, but for all columns A through Z.
Something along the lines of:
If Range("A1").Value = "Copy" Then
Range("A2:A7").Copy...
Hi Guys,
Hope you can help.
I need to know some VBA code so that I can count the number of rows on one sheet (not including header row ) then apply that number to a formatted range
Part 1 Extract count.
Sheet 1 is an extract of data and has a row count of 4 but I only need a round count...
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"...
Hi all, as a newbie, I got a copy-paste problem using VBA. And here is the snapshot of my minimum working environment.
At the end of each month, we will get data for column C and we were supposed to paste Column C data to the green area in order to get the total number.
By using a little...
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.