When a user clicks the drop-down on a group of DataFields in a pivot table, the user can use checkboxes to show all or some of the existing fields. However, if a user unchecks a box for a fie...
Hello Experts,
I need some assistance writing this If then Else statement in Excel. I've only really begun to dabble in Excel and you'll find the logic I'm hoping to translate is written mo...
How do I count the unique entries in a column A (20000 rows) based on a filter in column B?
A B
USA North America
GB ...
I am using Excel 2007. And it seems that you can still open a DBF (dBase) file in Excel but you can't save it in DBF format. Is there any solution to this? I would like to make some changes in...
I am trying to put together an excel spreadsheet where I enter the local date in one cell and the local time in another. I want to convert to the equivalent zulu date and time automatically. ...
How do you fix this error?
Microsoft Visual Basic Run-Time Error '53': File not Found: ADTMSOADDIN.dll
Thanks, James
Hello all.
I need to count the number of characters in a cell. I say characters because the field contains numbers (formated as text, because of leading zeroes) and a dot.
So you have a...
Hello!
I am trying to create a pivot table using a macro. Using other websites, and macro recorder, I have pieced together the following code, but I get various errors with the Activeworkbo...
I have recorded a macro that copies a range of data and then goes to another worksheet and moves to the end of the existing range of data and pastes the data. This will be repeated daily and ...
We have one copy of office 2007. Evryone else is using office 2003. We are seeing extreamly slow file opening in the office 2007, about 1-2 minutes. Files are on the server (server 2003) Offic...
When a worksheet name changes by a user, one can include code in either:
Private Sub Workbook_Deactivate() or Private Sub Workbook_SheetSelectionChange()
However, a user could renam...
I have an excel spreadsheet with about 300 lines in it, each with a hostname on it.
I want excel to do an nslookup on each host and make a cell next to the hostname the IP address that is r...
I'm not sure if I should be using the trend or forecast function in Excel or maybe even something different all together.
I have a data set for each week of 2005 and I would like to extrapo...
I have an Excel spreadsheet form that is filled out be various users. They will provide information in columns A and B. I would like to create a macro (or something) that will query an SQL dat...
Hi.
I'm using a macro that emulates the "advanced filter" command, so that when a button is pressed, a block of data is filtered, depending on various criteria, which is dynamic (i.e. it can...
Apparently you can use the evaluate function to get a result of a virtual cell, when you want to "evaluate" the value of a formula containing variables in VBA
For some reason the following ...
Hello guys
I am googling for convertion between decimal and hex numbers and I found a lot of articles mentioning the HEX2DEC and DEC2HEX functions. I want to use them but my Excel installat...
I would like to, from a vbscript file, open an Excel file, select a sheet, and insert a column. Easy enough, but not really :(.
Thanks.
Good afternoon,
I have used our CA to create a digital certificate to sign an Excel macro. The certificate is from a trusted CA and is set for 'Code Signing'. When I attempt to sign the mac...
I've never had a good vba solution for deleting rows, and now I have a project that requires one.
I have a workbook with about 300 tabs, each of which contains a data set, and a chart based...
I am trying to write the VBA code in excel (macro), which does the following:
1. Open external xls sheet at: Q:/exceldata/graphs.xls
2. Copy the chart OBJECT 'DecemberFigures', in workshe...
How to share excel file for multiple user,
I want UserA, UserB and UserC to add data entry for column 1 to column 6 on same sheet same time
OR
Users can use sheet1 for data entry and all us...
I created a macro and stored it in my Personal workbook so that it could be accessed from any workbook. However, I need to either edit or delte the macro as it does not work properly. Howeve...
I have a macro that does the vlookup from one sheet to the other, the code's below..
Application.CutCopyMode = False
ActiveCell.Formula = _
"= VLOOKUP(RC1,'[" & wb2.Name &...
When I convert an XLS to CSV, lots of special characters are converted to ?. I think that the new CSV file is not saved in the UTF8 format, despite the XLS file containing all needed special c...
