Need Help With Finding Date And Copying Everything To The Right Of

Need Help With Finding Date And Copying Everything To The Right Of

Post by Sm9lb » Sat, 19 Apr 2008 01:39:00


MyDate = DateValue("4/17/08")
FirstDay = MyDate - Weekday(MyDate) + 1
With Sheets("Sheet1")
For Each cell In .Range("3:3")
If cell.Value = FirstDay Then
.Range(cell, .Cells(3, Columns.Count)).Copy _
Destination:=Sheets("sheet2").Range("A1")
End If
Next cell
End With
 
 
 

1. multiple ifs & ands indirect/offset...need help desperately please

2. multiple ifs & ands indirect/offset...need help desperately pl

hi Shane...sorry - the folders are the inbox, selected etc. & the values are
the numbers under each. i will try to make a better example...i see it didn't
translate well below.

what i am doing is pulling numbers from a database and exporting them into
an excel spreadsheet which is my raw data/source file. the database is
broken down by the folders in which the candidates sit...inbox; scheduled for
interview;selected...etc. Source info is set up as in the table below:

Inbox Intv Sel Hird
city st jc
atl ga 123 55 30 17 10


from that i am populating a summary sheet for my clients which are assigned
multiple locations (cities) and titles (job codes).

So i have a client that is assigned atlanta, ga for customer assistants
which is job code 123...and i need to retrieve the number of candidates in
each folder/category in a snapshot/summary and i want to do this for each
location/client/job code

i need a formula to go out into the raw data to find the city...then look
for a specified job code then populate the cell below each category (inbox,
intv, sel, hired) with the corresponding number of candidates in each of
these categories. so that i can summarize each of my clients locations.

does that make sense?

3. if & ands and either indirect or offset - need help fast pleas

4. if & ands and either indirect or offset - need help fast please

5. Need help sorting out ANDs and ORs in parameter query

6. Microsoft's founders copied everything they ever did, right?

7. Trying to find the best way to get everything right xp 64 bit

8. I need help finding the right memory chip for my pc

9. NEED HELP to FIND the RIGHT PRODUCT/ SOLUTION

10. Help needed: Is Quick-Union-Find the right solution to this problem ?

11. NEED HELP FINDING THE RIGHT PLACE TO GET ANSWERS ON MS STREET & TR

12. Help needed: Is Quick-Union-Find the right solution to this problem ?

13. NEED HELP FINDING THE RIGHT PLACE TO GET ANSWERS ON MS STREET

14. Need help finding the right forum

15. Help needed to find the right cable