Macro/VBA for finding data locations outside Excel

sjandavid16

New Member
Joined
Mar 5, 2020
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
Hi All,

I have here a problem wherein I want to find the location of a certain data with no match outside Excel.
Below are reference photo and explanation for clearer description of the problem.

Here are the locations of the data that I will be putting in Excel.
1583454895200.png


This is a sample of what's inside the notepad, I usually use the numbers beside FD in finding the missing data, manually.
1583454971757.png


And this is the sample of what they look like in excel, as you can see below.
The Column H is where you can identify the Date and the Column I is where you can find the time, so I usually just sort them out so I can find the data in notepad
1583455156675.png


FYI, the last 6 digits of the notepad's filename indicates the date and time (for ex: 202003060320 - 2020 is the year, 03 is the month, 06 is the day, 0320 is the time)
so basically I just based the manual finding of the data through the time.
-
If you have any solution or suggestion regarding my case or an application that can help me, it's all very welcome.
Thanks to you all in advance and Good day everyone!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,224,820
Messages
6,181,159
Members
453,021
Latest member
Justyna P

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
Back
Top