solution don't work

when spaces are between numbers

in columns B

sometimes spaces will be
eachDdigitT.xlsm

I would like to have one excel file open on Monitor 1 and another excel file open on Monitor 2. I would prefer to NOT have to expand the Excel program window across both monitors. Is there a way to open an excel file in a separate window?

automation_t4.xlsmI am stuck on a macro. I am trying to use a data range that might change in number of cells used on sheet 1 as a driver to match to a set of values in a column (which might also move locations) as it comes out of a reporter that is used differently by each end user. If the values of the range on sheet 1 match and sheet 2 i want those rows hidden so that only the rows that match show, if the value shows up twice on sheet 2 (isn't unique) choose the first one.   I have used a search to find the row that i need to identify the column regardless of the location move for sheet 2, but i can't get the hide loop down. This is what i have. Any help you provide would be appreciated.

'Sheet 1 data range but again this length could change
Set Fin = WST.Range("B7:B15")


ThisWorkbook.Sheets("Data").Activate

 ' first line of data*.
actC.Select 'starts from J3 on data sheet actC is the result of the search parameter
      ' Set Do loop to stop when an empty cell is reached.
Do Until IsEmpty(ActiveCell)
    If ActiveCell.Value = Cells(Fin, 2).Value Then 'causes mismatch error
        Fin = Fin + 1
    Else
    ActiveCell.EntireRow.Hidden = True
         ' Step down 1 row from present location.
    ActiveCell.Offset(1, 0).Select
    End If
    
Loop

Select all Open in new window

Hello,

Here is some of my code It is failing on the last line

oWorkApp = CreateObject("COM", "Excel.Application");
&oWorkApp.DisplayAlerts = "False";

ObjectSetProperty(&oWorkApp, "Visible", True);
&oWorkBook = ObjectGetProperty(&oWorkApp, "Workbooks");
&oWorkBook.Open(&fileTemplate);

Examined all file permissions but still not working:
OLE Automation error in Workbooks.Open: ObjectDoMethod: Microsoft Excel cannot access the file '\\filepath\TDX_Template.xlsx'.

Any help would be greatly appreciated.

I have an excel spreadsheet with 950 patients each of which can have up to have procedures on one date.  Some of them have had more than one admission.  The column headings for example are Patient ID, Procedure Date, Procedure 1, Procedure 2, Procedure 3 etc. up to procedure 8. I need to count the average procedures for each admission.  What is the best way to set this out on a pivot table please?

EE Pros,

I'm looking for a macro that notifies a Excel WB User that two numbers are not =.  In the attached mock up, the "Imputed Tax Rate", calculated by dividing Income Tax by Net Sales, is different then the "Effective Tax Rate" which is entered as a number in a different cell.

I am trying to notify the user by a text box, a message or "comment" that only shows when the User selects the Effective Tax Rate Cell, or hovers the cursor over it (In the Mock Up, cell M19).  The only other conditions are; if the numbers are "=" there is no need to display the notice.  If the Income Tax cell is -0- or blank, the Imputed Tax Rate is then also -0- and may be displayed as compared with the Effective Tax Rate.

Hopefully this is an interesting challenge!  And as always, "thank you" in advance!

B.
Notice.xlsm

Need someone help me automatically populate fields from hundreds of sheets (tabs) into a single summary sheet.

We replicate the Master sheet each time, rename the sheet to the latest number and then fill in the details. We need all those details to flow through to the 'Actual vs. Forecast' sheet.

Any questions please let me know.
Copy-of-Costing-Form.xlsx

How do i use macro to auto update my formulas and cell references? I have a pivot table containing sales data, with the columns stating months from January to March. But for every start of the month, i need to update the latest month (i.e. update to April when it's May) to show to a new column. I cant use getpivotdata because i need to track the cell reference, and the data will change for each month so i cant pre-count April's values. Beneath the pivot table, I have a normal table stating sales data total [i.e =sum(Jan-Mar)] which i have to manually update. Is there any way for macro to automate the normal table to update =sum(Jan-Mar) to Jan-Apr? Example like =sum(b1:d1) to =sum(b1:e1) and for subsequent months?
Book1.xlsx

I am trying to read an XML file like the one below into an Excel sheet
      <Item>
            <Filename>H:\MrX@gmail.com\inbox\Company\file214.txt</Filename>
            <Location>H:\MrX@gmail.com\inbox\Company</Location>
            <ShortName>file214.txt</ShortName>
      </Item>
      <Item>
            <Filename>H:\MrX@gmail.com\inbox\Company\===file215.txt===</Filename>
            <Location>H:\MrX@gmail.com\inbox\Company</Location>
            <ShortName>===file215.txt===</ShortName>
      </Item>      
      <Item>
            <Filename>H:\MrX@gmail.com\inbox\Company\= file216.txt =</Filename>
            <Location>H:\MrX@gmail.com\inbox\Company</Location>
            <ShortName>= file216.txt =</ShortName>
      </Item>      
      
I am using the following intructions for read the xml file and copy it to the working sheet

## all dim etc omitted to make this shorter

Set list = xDoc.SelectNodes("//Results/Item")
        For Each Node In list
            iRow = iRow + 1
            '***Note: node names are Casesensitive***
            On Error Resume Next
            mySheet.Range("A" & iRow) = Node.SelectSingleNode("Filename").Text
            mySheet.Range("B" & iRow) = Node.SelectSingleNode("Location").Text
            mySheet.Range("C" & iRow) = Node.SelectSingleNode("ShortName").Text
 etc
 My problem is that when the file name starts in "=", no shortname is copied
 That is, mySheet.range ("C"&iRow) is empty in cases 2 and 3 from the example above:
 
 Questions:
 Why is this happening?
 Other than equal sign, are there any other initial character that causes …

i have 300 rows

each row has 12-60 columns of data in it, but each row has a different starting column . i need to create a new column, B, and put the sum of the first 12 columns with data into it.

must ignore cells that have just a "0" in it.

for example, row 25, has 0 in columns 12-34. So I need column B to equal the SUM of B35-46

THANKS!

I have three ACCESS queries that i re-run from their excel SAVED EXPORTS. I have these excel files saved in a folder on my local drive. I then manually copy and paste the data from the three files into one workbook. Each excel file has its own worksheet. the master workbook has headers and i just copy the data from row A2 and onward.

I would want a macro that would run the saved exports from the folder and copy and paste the data from the files into the one master workbook.
sheet1.xls copies over to "cars" tab in master workbook
sheet2.xls copies over to "color" tab in master workbook
sheet3.xls copies over to "model" tab in master workbook

Your assistance is greatly appreciated!

Is there a way to get a line break in place of the dash in the formula below?

B4&"-"&"$"&ROUND(C4,1)

I would want 1424-$6.3
 to look like
1424
$6.3

I had this question after viewing Auto refresh webpage but maintain scroll position.

I love the assisted solution, but when using a .mht file it does not work.
Internet Explorer asks if I want to open the file and the mht file opens in a new window.

How can I open, refresh (and stay on scroll) of an excel generated mht file?