Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automaticly copy data from one worksheet to another
I am trying to find out if there is a formula that will automaticly
transfer a row of data to another worksheet in the active workbook once a certain cell is populated???? just in case this sounds confusing let me clearify.... i have a main spreadsheet that has data for 3 companies, I want to just put a "x" in a certain cell that will then make that entire row of data copy to the worksheet designated for that specific company.... PLEASE HELP!!!!! thanks in advance! |
#2
|
|||
|
|||
Hi Emily,
A formula cannot change the value of another it can *ONLY* return a value. For what you want, you would need to use an Event macro based on a cell that you Change a constant. http://www.mvps.org/dmcritchie/excel/event.htm#change --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm wrote in message oups.com... I am trying to find out if there is a formula that will automaticly transfer a row of data to another worksheet in the active workbook once a certain cell is populated???? just in case this sounds confusing let me clearify.... i have a main spreadsheet that has data for 3 companies, I want to just put a "x" in a certain cell that will then make that entire row of data copy to the worksheet designated for that specific company.... PLEASE HELP!!!!! thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions | |||
How do I copy page set up attributes from one worksheet to anothe. | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |