Quote:
Originally Posted by NoSparks
Oh boy, now I'm really confused. You shouldn't need to be flipping names back and forth.
Back in post #2... I asked "What's in row 1 and what's the name of the sheet?"
Post #3... "just the same data as you see in the pic and the name of the sheet is Utility ID."
Should that response have been the name of the file is Utility ID ? and the sheet is Sheet1 ?
If yes, is a few files all using Sheet1 for their 8 columns of data ?
|
I'm confused now NoSparks. I thought whatever name I saved a file was the sheet name. Say in my Utility ID (file), I thought that was 'Sheet1' and when I opened up ScratchPad, that was 'Sheet2".
08-11-2018, 01:53 PM
Similar Threads
Macro to sort columns
Windows 10 
Office 2013
Threaded Mode