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
Quote:
I have a few other projects that I need to do and they all use the same layout
|
a few files all using Sheet1 for their 8 columns of data ?