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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,215,053
Messages
6,122,888
Members
449,097
Latest member
dbomb1414

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