new workbook

Hi, I have spreadsheet of data, I need to extract any rows that have blanks cells in columns F or P or T. If possilbe I would like a macro I could run that would cut all of the rows that meet the above criteria and paste them in to a seperate sheet. Any help is much appreciated, please...

I wish to make new sheets from a large worksheet of data. The data for these sheets will be based on groups of states and designations (red or green). So if Group 1 is the TexArkAna states, I want a sheet for group 1 red, and another for group 1 green. I then want to export these 2 new sheets...

With the following formula I keep receiving #Value. =IF(OR('[NEF.xls]NEFAR MASTER LIST'!$C$90:$C$96='Sheet2'!D2),'Sheet2'!E2,"") I would like it to return the value from E2 if D2 value is equal to any of the numbers between C90 and C96, if not do nothing. Any ideas why this is not working?

I just got Excel 2010 and am still getting used to the changes. I'm not sure exactly what is going on now but when I try to copy a worksheet into a new workbook...sometimes it works and sometimes Excel just completely closes everything, both the active workbook and any other workbooks I have...

Hi, I have an excel sheet that contains finance information for several cost centers. What I need to do is, filter each cost center, copy the information to a new workbook and save the new workbook. For example, if there are 15 cost centers in my file, I need to filter the data 15 times and...

Good Afternoon people. I have been using this site for various macros over the last 3-4 years and have never needed to register as I found most of the answers. But I have now cause I never seem to find just what i'm looking for this time. I do have very basic VB knowledge, so please excuse me...

Basically ive got a workbook (savings mth 4) with hyperlinks to excel files (which are called GW3 forms), when I copy the hyperlinks to another file (savings mth 5)it says Cannot open the Specified File. If I copy and use "paste as hyperlink", it links to the Savings mth 4 and not the orginal...

My office has just upgraded to Excel 2010. When I open a new workbook it always automatically shows Property Views ribbon. How can I open without this? My IT dept doesn't know. http://files.engineering.com/getfile.aspx?folder=698ee895-f313-434d-b4b0-984dd0627a8c&file=temp_110615.bmp I hate...

Hello all, I have the following issue that I would really appreciate some help on: I have a third party application (AB) that generates an output that can be exported to an excel workbook. The workbook is automatically named "Book1.xlsx". I would like to manipulate "Book1.xlsx" from a macro...

I have written a macro that copies worksheets from a workbook to a new workbook and saves it. I want the new workbook to save to the same network file folder as the original. It seems like everytime i run the macro it saves in a different location. Sometimes in the correct location. Often...

I'm trying to copy some data to a new workbook all on one worksheet from multiple sheets in another workbook. My code keeps breaking at the point where it makes a new workbook (.SaveAs Filename). It gives runtime error 1004. I'm not sure I have the copy values set correctly either but can't test...

Hi, I've been around this issue for too long and I believe it's a simple thing to do but I'm just not getting it. I've a userform (UserForm1) where the user selects the worksheets to copy into a new workbook by checking comboboxes. After selecting the worksheets, the user click ok...