Looking for a vba code to search for the value in sheet 3 A1, in sheet 1 BE2 to BW 6. When found, then search for criteria in Sheet 3 K2:T2 in Sheet 1 BD3:BW 23. When both criteria are found copy and paste the data into sheet 3 K3. I have attached an example of what the data is suppose to look like. The valube in sheet 3 A1, is not constant it will change upon certain conditions. Data.xlsx
Apologies but my code above would pick out 15 if 5 were entered as it was looking at any part of the cell in the find method. Its corrected below.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…