I am trying to use a macro to insert a column with B1 called "domain" and then fill the rest of the worksheet (wherever it may end) with the worksheet name.
the CSV that I open up has the domain name as the worksheet (example excel.com). I want to take that and fill B2 and all the way down to where the data ends. Its random for each spreadsheet.
I was able to record a macro to insert the column, but I just cant seem to figure out how to get the ws name and fill that in the rest of the column.
Or, can I pull the filename (minus extension) and fill the column?
thanks in advance!
Chris
Bookmarks