So let’s say that I want to find rows that begin with "Excel" In order to better explain the following point, I’ve added in a fake row of data to row 45, see below. The other thing to bear in mind is that if you intend to do multiple extracts for different queries to the same cell "J1" in this example, then it’s best to wipe the previous result data (in columns "J" through "O" in this example) prior to your next extract, otherwise things can get confusing, but if you’re extracting to different areas for each sub report, then that’s not a problem. The YouTube video that goes with this post (Which you can watch on YouTube if you prefer) will demo this "live" well live-ish -). Now that I’ve demonstrated how to perform the extract, in the next examples I’m just going to focus on the criteria differences for different reports.
0 kommentar(er)
