If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Pull Data With IF Statement And Sort.
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Pull Data With IF Statement And Sort.

#1
July 8th 12, 05:37 PM
 omen666blue Junior Member First recorded activity by ExcelBanter: Jun 2012 Posts: 14
Pull Data With IF Statement And Sort.

Hi guys,
Iv come to another problem in my rostering forms!
Basically i want to pull all my Data From The rostering Cells (For each Day) Display them in Another sheet (Calculation Sheet) Only If they Have Roster Number i.e 5610-5634 (rostering numbers for each job 10-34) If they Have RD or SP Not to Pull Them (Or not to Display them Whatever is Easier).

Then I Want Each Table to Sort its 2 Columns Using The Diagram (Roster Number) As a reference (Smallest Number to Highest)

If this is possible Please teach me how Thanks!

From here (DiAgram AND HRS)

Into here (DIA AND HRS)

#2
July 12th 12, 04:02 PM
 omen666blue Junior Member First recorded activity by ExcelBanter: Jun 2012 Posts: 14

Quote:
 Originally Posted by omen666blue Hi guys, Iv come to another problem in my rostering forms! Basically i want to pull all my Data From The rostering Cells (For each Day) Display them in Another sheet (Calculation Sheet) Only If they Have Roster Number i.e 5610-5634 (rostering numbers for each job 10-34) If they Have RD or SP Not to Pull Them (Or not to Display them Whatever is Easier). Then I Want Each Table to Sort its 2 Columns Using The Diagram (Roster Number) As a reference (Smallest Number to Highest) If this is possible Please teach me how Thanks! From here (DiAgram AND HRS) Into here (DIA AND HRS)
any idea guys?

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Pull text from cell with if statement Doug Excel Discussion (Misc queries) 2 February 18th 09 08:35 PM using an IF statement from a pull down box Jason Excel Worksheet Functions 7 January 2nd 09 12:58 PM pull data from a table and sort into list PL New Users to Excel 4 June 26th 07 12:20 AM Setting up an If-Then Statement that will pull from a valdiated li govols865 Excel Worksheet Functions 2 January 12th 07 10:48 PM How do I get an IF statement to pull a date range?? Brooke Medvecky Excel Worksheet Functions 9 April 19th 06 08:48 PM

All times are GMT +1. The time now is 01:28 AM.