copy & paste from sheet

I have a series of spreadsheets in their own workbooks but all contained within the same file folder in my Mac. I would like to create a new spreadsheet that would monitor these other sheets and when the word "Call" appear in column H of any of the spreadsheets the entire row is copied and...

I am trying to write code to copy a date range(with times included) to another worksheet in the same workbook. Example: eachdate range in column E would include only one month (say June dates) and only thatdata would go to a new worksheet. Then it would move to the next month incolumn E (say...

Good Evening, I have a sheet called Employee List which holds information on every employee and what tests they require. However, when employees need booking in for tests it takes a fair bit of sorting, is very time consuming and messy which leads to data input errors. I was wondering if...

I hope you can help me with on requirement, I have 10 columns data in Sheet1 and during my working, I can change any data in these columns...but usually, these changes anywhere in the row...same data in Sheet2 and whatever changes to in sheet1 should automatically replace the values in Sheet2...

Hello I am on MAC right now, I have 51 spreadsheets with 50 rows and about 25 columns each one, I tried to consolidate but there are many errors when there is a blank column, cell or row. Is there a way to just copy in sequence the lines data from A1 to Z50 from all spreadsheets to one? Any...

Hi there, I currently have a master invoice template that I use for invoicing customers. I have put some automation on this such as next invoice and save as pdf to a particular drive. I am looking to capture specific data from the invoice template, when I click the "save to PDF" button, to...

I have 3 sheets in excel in Sheet 1 there are 2000 rows and 28 columns till AB.In sheet2 I have the following data <tbody> TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_ddlkhata CONTENT=% TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm...

Hi Guys, Can you possibly help me out on the macro I'm trying to sort out? Basically, I have this excel file named "MasterList" with two tabs sheets namely: Master & Reference. The master contains a list of data while reference sheet has list of countries and its equivalent country group...

Hello all! I am new to VBA and I am having a hard time figuring this out. I want to move an entire row to "Sheet1" if column "H" has the letters L5P in it. Once the row is moved to "Sheet1" I want it deleted from the "ActiveSheet" I want this to work on multiple different files so the first...

Hi, I have a reference sheet called 'Hosts List' which has one row per host. It contains lots of term dates which are grouped by academic year. There are six columns of term dates per academic year which go across the sheet, with multiple academic years. At the start of each group of date...

Hello Excel Wizards, I have been experimenting with this all week, but I continue to get errors. Any help would be appreciated. There are two sheets, 1 and 2. Sheet1 Column A is a drop down containing the value "New". When "New" is selected, I need values from Columns B:E in that row to be...

Hi, I need to create a nested loop involving a find, copy and paste but don't know how to. There are two sheets, ws and ws2. In ws, where acad_year is a certain value, the first loop goes through the list looking for pop_fin (the unique id of the record) and matching it up in ws2. However...

Hi guys, I have a question, and would like to hear your thoughts :) So in sheet 1, I have the following: <tbody> Company Data1 Data2 Priority company1 information information 1 company2 information Information 3 company3 Information Information 2 company4 Information Information 1...

Hello, I am newly registered but not new to search in this forum for new approaches of better structuring my vba code. Still, now I am facing a wall with which I think the solution would be a nested loop (but I might be mistaken:confused:). Document: 1 workbook, 13 sheets (the first is called...

I have a file Auto Generated that has 2 columns - First labels and Second values Then I have a Master Reference sheet which contains references to cells from different sheets in a sub folder that contains values needed for the Second column in my Auto Generated file. Can I macro be prepared...

I have a workbook which I need to copy rows to a new worksheet. One of the columns is called Vendor. I have 12 different vendors, but 3 of them have different entries. Let's say column "C" is the vendor column and contains the following: Vendor 1 Vendor 1 Onshore Vendor 1 Offshore Vendor 2...

Hi All, I have an excel workbook with with more than 40 sheets. Sheet 1 is the main Master Sheet where I paste the data from the other sheets as and when I want 1 after the other. I have worked out a macros for the same but am looking out for a shorter way to get the data. Sheet 1 - Master...

I'm needing some help with creating a VBA code for the following: If a Name is entered into Cell C3 on Sheet2 in Workbook and it matches any of the Names in Column A on Sheet1. Then I want to copy the entire row of data in sheet1 to Row1 in Sheet2.

Hello, I am still a beginner to macros and learn quickly by reading forums on other's experiences with running macros. So let me explain what I am trying to do and I believe I am failing miserably. I am wanting to get the macro to copy the date from sheet 1 and paste it is cell A1 on sheet two...

I have code to copy rows of data to another sheet if the cell in column L equals "High" or "Extreme". I'm unsure how to copy only certain columns of that row to the new spreadsheet, which has matching headers in place. I'd like to either copy columns 2, 3, 6, 12, 14, 18, and 21, or have the code...