Excel data splitting
Budget: $30 – $250 AUD
Dear expert
I need to find a solution to for splitting out a master data source into different files without copying and pasting it out. I'm using a FILTER formula but I'm worried about security issues between the files. I'm wondering if my only solution is to use a macro to split out the data into separate files then copy paste the values. Each of the files are used as dashboards so they are also quite large in size. Not quite comfortable uploading a file for security issues but really looking to have a chat with someone to see if there's another solution.
Kind regards
Justin
I need to find a solution to for splitting out a master data source into different files without copying and pasting it out. I'm using a FILTER formula but I'm worried about security issues between the files. I'm wondering if my only solution is to use a macro to split out the data into separate files then copy paste the values. Each of the files are used as dashboards so they are also quite large in size. Not quite comfortable uploading a file for security issues but really looking to have a chat with someone to see if there's another solution.
Kind regards
Justin