Previous Topic Next Topic

EXCEL

Closed
Goober - Aug 30, 2010 at 10:42 AM
 Ray - Aug 30, 2010 at 03:57 PM
Hello,

How can I have excel copy the entire row of data from excel file "sales" to another excel file called database if column N contains COMPANY. I've tried almost everything but nothing is working. Please help! How do i write this formula?
Related:

1 response

Answer 1 / 1
Ray
Aug 30, 2010 at 03:57 PM
How about creating a pivot table in the database file with the sales file as the source. You can then filter the database file for the company you are looking for. If you really need a seperate copy the just filter the pivot table then select the output and copy and Paste Special, Values into the new location.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response