Forum Discussion
Excel Macro or Pivot Table Help
Lorenzo https://piecommission-my.sharepoint.com/:x:/p/pat/EfbjayAN6ylOqIOxR_X-6bUBwbyY_B7b6xANIcgagIcXRg?e=arO5F8
Link is linked. Thanks for the reply!! I would like to retain:
Columns A, C, F, L, N, Q
That's it!
Thanks in advance for any assistance.
The file you shared is not a CSV file but an Excel file with a .csv extension
Please clarify what your actual source file type is and re-share the actual file - Thanks
- Hi there - that was the actual file. sorry, i refer to excel files with csv extensions as csv files! the output file is, in fact, an excel file with a csv extension.
Hi PieGuy
i refer to excel files with csv extensions as csv files! the output file is, in fact, an excel file with a csv extension Very confusing. Not my call though...
I assumed you would have to do the same thing on a regular basis...
- Download the attached file
- Go to sheet Param
- In B1 enter the full path to your non-csv file
- Switch to sheet QueryOutput
- Right-click in the blue table > Refresh
Lorenzo WOW! Thanks so much. It looks amazing. i was having a little trouble replicating it though.
- I exporting a new source file,
- saved file to my hard drive
- copied that file pathname to Param / B1
- went back to Output Query and right clicked and refreshed and nothing happened. any suggestions? Thanks again for all your help. the final product is perfect.