Hi, I hope I'm wording this correctly. I have a large CSV file that I import using data>get data>from CSV file. it imports into cell A4 and it's a query. I tried recording a macro to format it like i want to but when I use the macro the column that I moved from column H to column B shows up blank and some of the other features don't appear to work.
my question is, is there a way to change this query format into general excel where recording the macro will work? I need the current format in each column to remain the same
my question is, is there a way to change this query format into general excel where recording the macro will work? I need the current format in each column to remain the same
