Hi,
I'm trying to copy cell's A1 - A?? (depends on data on a different tab) to a .txt file and save it.
I would like to take cell's A1 - A?? on tab "Upload -copy to notepad"....and save this information into a .txt file. All of my information is concatenated in column "A"....my problem is getting it to stop pulling data when we tell it to.
The "??" is based on tab "Type 45 - Template working"... I need to check each cell from F36-F160. If data exists there, then I need to run a loop until that data stops...which will then tell me how man lines to go down.
So basically F36 on "Type 45..." tab is A1 on "Upload..." tab...if that make sense.
Any help would be awesome, and thank you! If any clarity is needed, let me know happy to provide!
Running Microsoft Office Standard 2013
I'm trying to copy cell's A1 - A?? (depends on data on a different tab) to a .txt file and save it.
I would like to take cell's A1 - A?? on tab "Upload -copy to notepad"....and save this information into a .txt file. All of my information is concatenated in column "A"....my problem is getting it to stop pulling data when we tell it to.
The "??" is based on tab "Type 45 - Template working"... I need to check each cell from F36-F160. If data exists there, then I need to run a loop until that data stops...which will then tell me how man lines to go down.
So basically F36 on "Type 45..." tab is A1 on "Upload..." tab...if that make sense.
Any help would be awesome, and thank you! If any clarity is needed, let me know happy to provide!
Running Microsoft Office Standard 2013
