excel
Excel VBA making different sets based on unique records and salary
I have below data EmpidEmpnamesalaryCompanylocationstatus xxJhon100IBMus x1Phil50IBMus x2Karl30IBMus x3Stev开发者_JAVA百科e20IBMus[详细]
2023-04-11 04:51 分类：问答How to delete rows in Excel based on criteria using VBA?
I am currently building a macro to format a sheet of data as well as to remove inapplicable rows of data. Specifically, I am looking to delete rows where Column L = \"ABC\" as well as delete rows wher[详细]
2023-04-11 04:29 分类：问答Looking for changes in cells - Excel files
I have 2 excel files with a lot of data in each. The data is structured exactly the same in both files but the values might have changed as the data is from two different times.[详细]
2023-04-11 04:09 分类：问答Error 3021, no current record has been found, Query data from Access to Excel
I\'m writing a function in Excel VBA which will be called to extract data from an Access database, I\'m using ADO connection. The function Get_g_gtop has parameters defined as bellow. Now, I try to us[详细]
2023-04-11 03:56 分类：问答Insert large amount of data efficiently with SQL
Hi I often have to insert a lot of data into a table. For example, I would have data from excel or text file in the form of[详细]
2023-04-11 02:44 分类：问答How to decode %C3%B8 in vba
How do i decode %C3%B8 in VBA? it is the danish letter ø - I开发者_运维问答t is encoded in UTF-8. I have tried to decode it in vba for use in a excel sppreadsheet with the following function:[详细]
2023-04-11 02:25 分类：问答Click RefreshWorkbook on Bloomberg Ribbon [duplicate]
This question already has answers here: Closed 10 years ago. Possible Duplicate: How to refresh/load RTD Bloomberg function (BDH) in excel in vba[详细]
2023-04-11 02:23 分类：问答Django Spreadsheet Application
I am in the making of a Django application where you will be able to upload an excel spreadsheet file and have it inserted into the application. But I sorta got the importingsorted out.[详细]
2023-04-11 02:08 分类：问答How to split a string with multiple delimiters in vba excel?
I want to split a string with multiple delimiters using Excel VBA.One of the strings is: d1-d2 d3 d4 We have a dash and a space as two delimiters. I tried the split function but it only do开发者_如[详细]
2023-04-11 01:54 分类：问答Excel: Data validations with dynamic range from separate worksheet
I am trying to create a data validation list whose source comes from a dynamic range on another worksheet. For instance, take the following layout[详细]
2023-04-11 01:16 分类：问答
加载中,请稍侯......