data ectract

I have a user form that dumps data into a sheet. at a future date a supervisor will type yes in an approved column if they approve the request. once they make the change in column F to "YES" i need to extract the data from that row so the data is columns A-E in the same row where F had the...

Hello all, I am new and still learning macros, using Excel 2010 on Wins 7. I am in need of finding/creating a macro that's purpose would be to: Go through every workbook in a defined directory (C:\test) Locate the Worksheet named "Change Log", in every single Workbook in C:\test In the...

I need to extract data from Sheet1 into Sheet2. The data being extracted is sample book analysis and each book has a series of row headers and column headers. The row headers are repeated for every book while the column headers are repeated once at the top. Each book is separated by a blank row...