alias

Let me first say I lack classic excel training. I normally use excel to solve problems as they arise, learning as I go. Thank you to those with training willing to answer these questions. I am attempting to use Excel to convert some CMUD XML formatting to BlowTorch XML formatting. My ideal...

While I have been working with Excel for several decades, I still a lot of blind spots. I was wondering if I missed that there is a way to alias a segment of a formula within the entire formula so that within the formula you can refer to the alias result? My example below is very simplistic and...

I have some extracted data into excel as a csv file and it contains lots of information, but I'm focused on the Alias. Then I have a list of usernames that has been given to me. What I would like to do is, if the alias/name match, export (extract) all of the data for that alias to a new...

Hi all, I have seen this requested on some occasions and the usual answer is to create a userform that looks and behaves like an inputbox and then use OnTime to schedule the closing of the userform upon time-out. In case anyone is interested, I am showing here an alternative that uses the...

Hi all, This is a little vba class that you can add to your project in order to catch mouse drag and dop operations performed on shapes embedeed on worksheets. The code doesn't use a timer nor does it use a loop so it is safe and should have much less impact on performance. If you set the...

Here's a query that works just fine on my SQL Server Studio. select t.converted_date as AsOfDate, a.acc_name as Name, mvs_mkt as Prt, a.field_7 as AcctType from IndataDB_MarketValues..tblMarketValues m, IndataDB_MarketValues..tblDateTable t, indatadb_main..rimsacc_Master a where m.mvs_counter...

So I have a spreadsheet on Google Drive that me and other people use for our employees. Every week we send out the spreadsheet to the employees for them to see. However, it does not help them because the spreadsheet is changing constantly. I need for them to be able to view the spreadsheet (or...

Here's a great problem that even I can't solve, but I see possible glimmerings of a solution. I have a giant database (250,000 records) and a smaller to-find list (35,000 records), though the sizes are a problem. These are both lists of peoples names and addresses from all around the...

I have a list of names in excel. The Outlook alias is in one column and is what I am passing to create an outlook message. What I really need is to also look up the managers name of the outlook contact. This could be done with two separate macros if needed. I was hoping that I could pass in the...

Hi, I've had this problem for a while and I haven't seen any answers to it yet. Hope you guys know better: I'm trying to get information to Excel by using an SQL statement that is run in Microsoft Query. Seems that MS Query doesn't follow SQL standards, because the following query gives me this...