New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Automatically Copy One Row of Data to a New Workbook

Macros, VBA, Excel Automation, etc.

Automatically Copy One Row of Data to a New Workbook

Postby WBI2070 » Mon Feb 22, 2016 2:06 pm

I have a large spreadsheet with 19 columns and a couple of hundred rows. I’m looking for a macro that will move an entire row of data to another workbook only if there is data filled in on a certain column. So if data is entered into cell P2, that row of data would be moved from WorkbookA to WorkbookB. There IS a header on the master spreadsheet.

I’m sure this is a simple fix, but I am at a loss.

Any help would be appreciated!
~Dre
  • 0

WBI2070
Rookie
 
Posts: 1
Joined: Feb 22, 2016
Reputation: 0
Excel Version: 2010

Re: Automatically Copy One Row of Data to a New Workbook

Postby pecoflyer » Tue Feb 23, 2016 3:14 am

Hi and welcome to the board

Perhaps post a small sample sheet ( no pics please) to work with and see what you already accomplished?
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 59 guests