ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copying a row of data using a formula (https://www.excelbanter.com/excel-discussion-misc-queries/451117-copying-row-data-using-formula.html)

[email protected]

copying a row of data using a formula
 
currently i have a worke book with lots of data init that im trying to make a litle easier to manage.
The logic im trying to use goes along the lines of
If workbook 1 f2,F809 = W1 then copy that row into workbook 2.
Is this possible at all? I did have a rudamental equation but i cant figure out the copy part of it. I also need this to be copied down the in the secound workbook.

Any help would be apreciated





All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com