I am new to VBA and would need help to write a piece of code for the requirements below:
i have a spreadsheet with 1000's of data
From the data in the column “N”, for each line:
Copy-paste all the objects starting with “L-“ into a new column named “Location Type”
Copy-paste all the objects...
I want to save activated worksheet i.e.template at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet(template) again.as i am doing this for number of files and also i want to add wrap text =true and row height set 12.75...
Not a strong VBA user
I have a formula in Cell B3, I need to copy this using VBA x amount of times horizontally to the right, x = the value in Cell B2. This will change each time hence the value in B2
Any help would be appreciated.
Regards
Andrew
Hi everyone,
I've search the forum for answers but can't find a solution I need.
I have no idea how to code VBA for this. Basically the workbook is used to work out a quote and then I would like to save the scenario used to another sheet so that I can look back to see what scenario I used the...
Hi,
I'm looking to create a macro that pastes the entire row (or I just need the first 11 columns) onto a new sheet based on cell criteria. The criteria I'm looking for is below and if any of them are true I'm hoping to copy the row over.
-if the age is under 19 or over 64 (column I)
-if...
Hello Everyone,
I am working on gathering some data on jobs that require very little assembly time and I am writing some script to automate that. In an effort to speed things up I am trying to resize the destination table to match the size of the data prior to copying. However, something is...
I reviewed message posted in the forum and cannot find any to assist with my code below.
The Data set has headers and is in Range.A4:AY & lastRow
I am filtering Data sheet from Columns Q4 & AG4
The visible date should be copied into the activesheet as follows:
AQ to activesheet Range. B2
AR to...
Please anybody help me to solve this VBA
I want to copy a range that if the specified cell is filled with value
in the picture attached is my file
if G9 is filled with value more than 0 then i want to copy from B9 to G9
i need only the code to select the range. i alrewdy have the copy code to...
Hello.
How to copy data from all worksheets in a workbook, into a new single worksheet, creating a new worksheet named "Combined" but not adding them below into same columns (last used row +1), but to the side. First data from the first copied worksheet into "Combined" shoud go into A1, then...
Hi All,
Just had to re-register after 8 years away. I receive a weekly timesheet spreadsheet for a construction project in an area with high rainfall. Each person can charge to 3 or 4 different time codes per day. One of the codes is "inclement weather/rain". When this code appears I need to...
Hi, I'm new to VBA and have been trying to find a code that will transfer data from sheet 1 to sheet 2 using an input box on the amount of rows to copy over.
Sheet 1 is where the user will input the invoice information from D6 to P6, once the information has been checked it would then be copied...
I hope everyone is having a wonderful new year so far. I'm really struggling with a macro I'm trying to build and I hope I can get some advice here :)
I have a sheet (called: "Motors") with 24720 rows. I'm trying to fill empty ranges with different intervals in column A and B with the values...
Hi everyone! I hope you are all having a wonderfull Christmas :). I'm having huge trouble with a macro which I'm trying to build for my small business, and I hope I can get some advice from you guys.
Every month I get a overview with my account receivables in a spreadsheet. Column A:T consists...
Hello,
I'm new to VBA and currently still learning. My problem is that I want to be able to copy a set of data from multiple worksheets in a workbook based on a date search and have these data paste to a summary worksheet in the same workbook.
For example: I want to copy data from sheet A-I...
I need help with a VBA code and have absolutely no experience/knowledge with it. I have looked into it but ultimately come up confused where i am suppose to change data to match my workbook.
I am trying to copy data based on one cell with multiple and changing factors into other sheets for a...
Hey All,
I am having major difficulties working out a macro formula for what I am trying to do, unfortunately, this seems way, way more advanced than my current skillset, and I can't seem to find any good video tutorials on what I am trying to do.
I am trying to create a macro with a button...
Hi everyone,
I'm trying to copy the range of the second table (green background), however I can only get it to copy the blue background table. I was trying to set it up so the "LastRow" was set to the row that the string "Total" is located. Which worked for my first function addSetB, which...
Hi, I would like a macro that auto populates a master sheet in a workbook based on two other sheets, sheet 1 and sheet 2, which will act as templates. The master sheet will have normal column headers horizontally but in sheets 1 and 2, the headings will be contained in column A and the data in...
Hi all, first off thank you in advance for reading and considering to help.
I am looking for assistance on a copy paste macro to copy data from Sheet2 to Sheet1.
the macro must Compare the values of columns C in the 2 sheets and if they are equal: copy/paste the whole row in sheet2
Example...
I'm trying to create a Macro to copy the values from a table T1 of sheet1 and paste them into the bottom of table T2 of sheet2 if the value in cell G (key) of sheet1 does not exist in in cell G of sheet 2.
If it exists, just replace the values of cell M of sheet2 by the values of cell M of the...
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.