Excel Tutorial - Display All Range Names

Hi
Thanks to this forum, I have been able to search a lot of functions of excel.
I have a scenario: In the given spreadsheet (image attached), I have A week start date in cell C3, C4... so on. Hence the week range is ">=C3" and "<C4" and so on.... Dates when people were paid in column D and names of people paid in Column E What I want to achieve: How many people were paid per week (note: I used a formula - see note in F5 cell, and this has worked so no longer a problem - requesting the excel gurus to validate my work) Who was paid. Example, in first week, 5 people were paid. I can get the count but this column should show the names like A, B, C, D and E. IS This possible? I am mainly concerned about the "who was paid" in a given week.

Update: I just added an alternate acceptable method to calculate - see "capture2.png" file attached. Can you help me with this calculation too?

Thanks. You'll really make my day!
Please see the attachments - image of excel.
Capture.png attached, capture2.png below
Capture2.jpg

Here's what my spreadsheet looks like: http://i.imgur.com/Gk7UN.jpg
As you can see, Column A contains a list of image filenames. Rather than the filenames, I would like the actual images to appear. This seems to be exceedingly difficult. I understand that I'm probably going to have to use VB for this, and that's fine, but I've never used it before. So, if there's code or something that makes this happen, where do I put said code? I really feel like I'm on the verge of graduating to the level of using VBA in my Excel and Access projects, but it's a whole new world to me. Please, if anyone has a solution to this, explain it to me like the ignorant newbie that I am. Thanks so much!

Anyone looking for an introductory tutorial on using VBA in Excel should
take a look at the new four part series at TechBookReport. The tutorial
is he http://www.techbookreport.com/tutorials/excel_vba1.html

--
TechBookReport: http://www.techbookreport.com

Hey guys,

Can any one point me towards a tutorial on how to set up meeting requests from Excel to Outlook?
I know this involves codes/scripts but I wouldn't know where to start

Cheers

Anyone knows some sites where they give free excel video tutorials? Appreciate it.

Hi, I'm new to this forum. Just wanted to give a link to a basic Excel tutorial my students enjoyed. Looking over this forum, it's may be too basic. It just teaches formatting, the AutoSum button, a basic formula, etc. I don't teach anymore and I miss being 'helpful'. Maybe some of you have a youngster who's just learning Excel. I gave this lesson to 4th through 6th grades, and some of them actually wanted a second tutorial like this one. Anyway, sorry for the long post...here's the link:

http://www.associatedcontent.com/art..._tutorial.html

Any good ones online that are like projects? I've seen ones that are
more like reference manuals, but i would like to work on ones that
simulate projects dealing ROI, P/E ratio, etc or anything in nature
like that. Thanks

At http://www.excel-vba.com/v-forms-controls.htm

I have followed instructions... my code on the form is below but it won't
run... I've marked the error...

Can anybody give me any help with this?

thanks

Code is below--------------

Private Sub cmdBtnSubmit_Click()
shReport.Range("C4").Value = cbxCity.Value
cbxCity.Value = "Select a City"
frmCity.Hide
End Sub

Private Sub cmdCityCancel_Click()

cbxCity.Value = "Select a City"
frmCity.Hide

End Sub

Private Sub UserForm_Activate()

shParameterst.Activate '<-----Run Time Error 424 - Object Required
cbxCity.ColumnCount = 1
cbxCity.RowSource = "A1:A5"

End Sub

Hi,

I've made an Introduction to SQL tutorial aimed at Excel users.

I would love to hear feedback on how to improve the tutorial, especially
if you are an Excel user without much existing SQL knowledge.

http://www.querycell.com/SQLIntro.html

Cheers
Sam H

I have gotten to a point in my database where I will need to use Excel as a way to "export" an attendance sheet and then import the collected info once returned. I am wanting to find some good sites explaining some of the ways to do this (I assume most of it is VBA).

Any links/direction is appreciated!