This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hey, newbie here. I've looked at one live training on batch macros and some help pages, but I'm stuck and hope someone can help me with this.
The goal is to clean FAFSA data, but each week of data must be cleaned individually before being unioned. Because they are all cleaned the same way, I'm not sure what to have as an action. I'm not even 100% sure if a batch macro is the appropriate tool. So any suggestions are welcome. I've attached my work so you can get a better of idea of what I'm trying to do.
The sheets weren't included in the package so I'm guessing here but looking at what the macro is doing I don't think you need to overcomplicate it with a batch macro...I think you can just use a normal workflow and make use of the grouping functions that most tools have.
I'd be happy to mock something up if you can provide some example data.