Hi peeps. I have this software where it exports computer specs in .csv format. only issue is that what should be headers are in the column (computer name, domain etc...)
I was hoping you guys could help me create a macro that would
1. select the .csv i want to import from
2. find specific words in the column
3. import the data associated in the next column
4. repeat for each specific bits of data
I would do a normal import but its a case of putting column stuff into a row. any ideas? give me a clue and i can do the rest lol.
I want this to be on a button command so an onClick() sort of thing then prompts to open file blah blah blah,,.,.,.
Hope your all well btw