VBA-conditionally selecting and copying data Closed

Question

Hello, 

I have a file with 5 columns. one with date, time, latitude, longitude and amplitude.
I need to conditionally select data from the latitude and longitude columns and paste them into a new workbook.

The file has a total of 32001 rows, including the title rows.

The conditions that i need are the latitude values should be within -37.9382 and -32.004 and the longitude values should be within 136.7754 and 141.0698

i am completely new to macro excel writing and i am completely stuck.

Ambucias · Answer

Behind every answer, to help given on the forum, there are human volunteers who give their time trying to solve users' problems.

Therefore, it is expressly requested from kioskea forums users to show their utmost respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

* Please, re-write your message accordingly, respecting the politeness charter and repost your message.

Please, thank you, appreciate, greateful are words among those forms

We trust that you understand

Moderator

VBA-conditionally selecting and copying data

1 response

Similar discussions

Subscribe To Our Newsletter!