listing

my current formula is =VLOOKUP($A5,'[2017-07 - Caseload Listing Details.xlsx]Caseload Listing Detail'!$B$2:$G$34498,6,FALSE). I would like for the "2017-07" to refer to any month that is entered in cell M2. So if M2 changers to 2017-09 then the formular would read =VLOOKUP($A5,'[2017-09 -...

Hi Guys, I am pretty new to VBA but I cam across a macro which lists out the hidden rows in a worksheet :- Sub ShowRows() Dim rng As Range Dim r As Range Dim sTemp As String Set rng = Range("A1:A1000") sTemp = "" For Each r In rng.Rows If r.EntireRow.Hidden...

Is there a way to connect a directory to a spreadsheet so that when a file is added to the directory, its information (file name, author, date modified, etc) is added to the spreadsheet. I am looking to keep track of what all comes into a certain folder. The following two programs are close to...

Hi there, please help me S.O.S. I have a table that lists 1000+ individual student details under columns labelled as ClassID, Name, ClassRoomNo, Subject1, Subject2, Subject3,.... Subject9. The subjects are text entries such as 'Psy', 'Latin', 'Math', 'Art', 'French', ... and so on. Each...

Hello, Every month I create a YTD statement and since this is done monthly I need to copy the formulas from on month to the next while hard-coding the prior-month. I have already created a macro that works exactly as I need it to, but what I need to be able to do now is add a portion to the...

I sell a lot of motorcycle items on eBay, and eBay's duplicate finder is slightly more advanced than Excels so I am having a little trouble. I work with a large list of bikes and sometime the strings of information get muddled into different orders. e.g. CBR125 Air filter Air filter CBR125...

I have a list in excel in column B , I have over 20,000 cells which I would like to count similar cells. here is an example of my list. <tbody> COMLUM A COLUM B Collision,Property Damage,Rental Reimbursement Collision,Property Damage,Rental Reimbursement Collision collision...

<tbody> I'm so new it hurts...but I'm trying. I just don't see this problem listed in the forum. What am I missing? A B C F G <tbody> TIME NAME AGENT ROLE/NOTES </tbody> </tbody> <tbody>...

Hi guys, Excel 2010 in Win 7 64bit I am adapting some code I found in another thread to first list all files found in a target directory and then want it to do some basic sorting. All I am really stuck on is getting the sub ListFilesInFolder() to list the different sub-directories in separate...

Hi I am trying to find a formula to do the following Ideally a worksheet formula rather than an array if possible If on Sheet 1 a cell meets a certain criteria then copy the contents of another cell (from sheet 1) to a certain cell on sheet 2. In sheet 2 make sure they are listed in a...

I have mutiple worksheets in one one workbook that is accessed by numerous individuals. I have a separate file maintaining the worksheet names (in column "A") and the corresponding individual passwords to each sheet (in column "B"). My intent is to loop through the listing and set the passwords...