mikeo1313
08-17-2010, 03:18 PM
I'd like to paste in all rows of a column the name of the speadsheet file.
for example. spreadsheet file = apples.xlsx
column C
apples
apples
apples
apples
apples
..
..
..
Seems pretty simple but I intend on running a macro on a folder of files, besides running some other formatting this will finish things up and save me having to go in the files one by one.
for example. spreadsheet file = apples.xlsx
column C
apples
apples
apples
apples
apples
..
..
..
Seems pretty simple but I intend on running a macro on a folder of files, besides running some other formatting this will finish things up and save me having to go in the files one by one.