dynamic sheets

I would like to find the largest value across multiple sheets and return the sheet name where the value is located in. The issue is that each week a new sheet is added so I can't create a static list of sheet names. The data are located in the same cell across sheets in cell B10. I have hidden...

Hello all, Having an issue with floating comments. I have a code that pulls in peoples names from a dynamic number of sheets and then incorporates them into a comment. However when I look at the comments, it only has one name, which is the last one it entered. Can someone tell me what I'm...

Hi, I am using a sheet in excel which pulls data out automatically from a database. Fills in maybe 20 or so columns with orderinfo. In column A i have a unique order no. What i want to achieve is adding a column for an example C that is static. I fill in a number related to the order and i...

Hi there, Here I come with another question that I can't seem to find answer to anywhere. I have following code that is responsible for creating hyperlink to a sheet whose name is the same as cell (r, 4) value: ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=Cells(r...

I have a if-elseif condition that give different sheet after operation(when the loop is runned). I want to copy this sheet as a new workbook, save as temp, email and delete. Need help with the code. Basically want the active sheet to be copied every time. Sub Send_sheet() Dim OutApp As Object...