vba & copy

I have been searching a solution and cannot seem to find one, is this possible, What I am trying to do is write a macro that will create a pivot table onto another tab. The sheet that the data is on is titled with a customer reference number which changes from workbook to workbook. Is it...

I have a worksheet that I need to copy cells in row 7 but I only the information from every 7th column for now. For example, the first few cells I need to copy are C7.J7,Q7. This file goes on for years worth of data. I tried =OFFSET(C7,0,7) which worked for the following cell but when I drag it...

Hello, I have an inventory of equipment, radios, and vehicles that is updated by many users. This update is sent either in total or in part to a fleet manager for insurance purposes. I have set up a user form for the department heads to use when an update is required. The user form allows the...

Hi, following request I had done before with the FormulaLocal(sverweis). Now I want to learn more about if loops, but I cant get it done. So I ask you for help to show me how to do it. Request - Reference worksheet uploaded: check if value in blue marked column of worksheet "Bezugsdaten"...

Hello folks, I am desperate to scan the tables via Vba and determine specific values. I have a master table (first table) that is automatically generated in a sheet every day. This table should be compared with the table on the left (here as an example below) and the data from the master...

Hello, I am looking to figure out this VBA code I am trying to write for a project I am working on, I have it that it will search for a certain text in column L, once it finds that certain word I want it to copy and paste columns A-K down from the row that it found the certain word until a...

Hello, I'm looking for some help on VBA. The code is to create a file to import into QuickBooks for invoices. I have some code i've written that takes a pivottable and copies it to a new tab. Pastes it as values and insets a blank line. I would like to add another line that is the "SPL" that...

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