tony

I'm looking for a solution to save a workbook to two locations. Location 1 is a folder on my local hard drive. Location 2 will be on either my OneDrive or one of the other cloud drives I use (not sure which, but probably the OneDrive). Would like the routine/macro to run from a custom button...

Hi Everyone, I'm try to make a list based on a name selected I'm getting stuck so please help if you can Column A has names in it Repeated lots of time with column be having interests, <tbody> A B C D E F G H I 1 nAME Interests Sub Chosen Name Unique List G is what i'm...

Hi Everyone, So I've got a document that has lots of columns and I'd like each column to be a dropdown list. the problem is the simplest way to create this list would be to use another sheet called "All Data" All data has the same columns as the tab I want the dropdown lists in but the names can...

Hi Everyone, I'm being invaded by excel tmp files, I have the IT network guy looking into it but I'm hoping someone can help me with a quick work around why he is taking his time fixing the problem What I would like is a macro that when I run it deletes all .tmp files from my "S:" including...

I’d like to select an entire row (or to the limit of a range) as show below in light blue, when a value (which is text) is supplied via an input. Something like: GetAgencyNumber = InputBox("Agency Number") Application.Goto (ActiveWorkbook.Sheets("Header").Range("B1")) Set cell =...