23/05/2018

  1. K

    Vba to loop on a text file and extract data into excel ( reading text file from vba)

    Hi John_w, I want to READ the String "TREASURY REFERENCE NUMBER: " when this string found, I want to extract columns, below 14 lines from the string , data in excel.Sample text file , required output in excel sample and the code I am trying is as follows...
  2. S

    Calculating how many hours taken between shifts

    I have been looking all over the web for something similar to what I am looking for but have not found anything so far which suits what I need. I am creating a time sheet where colleagues would input data for each employee, where they worked, start time and end time. As part of the law, we...
  3. P

    Index Match & sumifs question?

    So I have 2 sheets. The first shows a UID, dates when payments were made against that UID & how much was paid. The second contains the UID & when that UID was bought & sold. So I want to sum those payments against the UID between the bought and sold dates, between specific date ranges...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top