You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

To copy a row from one workbook to another based on criteria

To copy a row from one workbook to another based on criteria

Price: FREE

I want to be able to copy a row of data from one workbook to another based on the criteria of one of those cells in the row. I've tried something along the lines of an IF statement, but with no luck. can anyone suggest anything ?

Visit publisher's web-site: To copy a row from one workbook to another based on criteria

Category and Tags: ExcelTutorials :

Related Tutorials

copy rows to new sheet based on specific cell value

Free: Yes
Tags: Excel ›

Is it possible to copy an entire row to a new workbook based on a specific cell's value? Specifically, if the cell contains a "1" I would like the entire row to be copied to a new workbook. I know this can be done manually by sorting, copying and pasting, but the file is large and there are a few hundred rows that meet the criteria weekly. Any help is appreciated - it now takes a considerable amount of time to do this.

Copy data from a sheet to other based on a criteria

Free: Yes
Tags: Excel ›

out in the below task.
What I need is, in sheet1 if the "Service Date" column contains the words "Check#", the whole row should be copied to the next sheet as per the example attached.
Herewith enclosed an example file for your ref.

Make copy of workbook based on selected criteria

Free: Yes
Tags: Excel ›

I have created a workbook that I use to create the team rosters for a flag football league that currently has over 1100 kids and is getting bigger. Currently, it contains two worksheets named Players and
RosterMaker. I have data validation in some of the cells on the
RosterMaker sheet which removes the player's name from the dropdown list once it is chosen. The player's name is also removed from the available players list on the roster maker page as a fail-safe for me. I am currently looking to add a macro which would allow me to
choose the number of teams from 4-12, the number of players per team, and create a copy of the master workbook for the selected values. I would be happy to post a copy of the master workbook that I have

Copy row based on cell content

Free: Yes
Tags: Excel ›

I have a workbook with about 100 sheets; they are all formatted the same as far as rows, columns, etc. The data in the cells is different.
I would like to copy a range of rows based on the contents of a cell on the worksheet.
To further explain, I have one of three possible values in cell A1. Based on this value, I want to copy the range of A5:M13 to another sheet, named the
same as the cell.
I need to repeat this process for all of the sheets in the workbook.
I would like to automate the process because the sheets are going to be updated often, and I would need to revise this "summary" page after the

How do I find and copy rows based on specific criteria?

Free: Yes
Tags: Excel ›

I have a large spreadsheet and in one of the columns part of the data, some of the rows has a \t. Once I search on the \t, I don't know how to copy the entire row to a new worksheet. Your help is appreciated.
I am using Microsoft Office Excel 2007.

Related Applications & Scripts

web based file management solution

Free: Yes

efileman is a free web based file management solution written in Perl with the following features:
- create, copy, move, rename, edit, delete, upload, download, zip, unzip or change permissions of - files and directories
- multilanguage support
- multifile operations
- multiuser access
- full skinable
- web based user administration
- email interface

Copy to clipboard V1

Free: No
Tags: Flash › Excel Forms

Very easy to use. In this third version you can copy to your system clipboard the text contained in a text field and then you can paste it everywere. If you want you can copy a user defined string. You can change the graphic easily by editing the symbols in library. To let it works you just drag and drop it into your flash file

Explosion Effect Fx02

Free: No
Tags: Flash › Excel 3d Effects Animations

100% vector based explosion. Just copy and paste to your own project. As it is vector based, you can resize it easily. Looks good on any background, only 8kb in size!

PHP Random Password Generator

Free: Yes
Tags: PHP › Excel Randomizing

This script allows you to create your own list of passwords based off a specific set of parameters. You can either use my copy of the script (listed below under "See it in use") to generate passwords, or you can download a copy of the PHP script and make your own modifications.
I constantly found myself needing to create new passwords, either for myself or clients. I HATE passwords that I can't tell what the characters are by just looking at it. I also got tired of clients contacting me because they can't figure out if their password contained a 1, l, I or o, O, 0 when they read the old password they taped to the bottom of their keyboard (yes, we know you do that).

Jambai FTP - a web based online FTP client

Free: Yes
Tags: Web Services › Excel FTP

This service allows you to access your and your clients' FTP servers if you are behind a proxy or a firewall.Also can help you if you are on the go . We do not save or store any information used for FTP login. There is no worry that information will be stolen.
Navigate FTP, upload, zip/unzip, Download, Copy/Move to another FTP server, HTML editor, Code editor, file size calculator etc...

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing