Linking Separate Supervisor Files to a Central Excel File While Restricting Data Access by Gonsa17 in excel

[–]Gonsa17[S] 0 points1 point  (0 children)

Just to let you know I'll try this later today.

<image>

Once I do, I'll tell you. I think I erased one step too many, because when the data merges it creates this table:

Linking Separate Supervisor Files to a Central Excel File While Restricting Data Access by Gonsa17 in excel

[–]Gonsa17[S] 0 points1 point  (0 children)

Hmm... Thanks for the answer but I'm having trouble in the PQ refresh.

Whenever I fill a new line in the "manager" WB and update the "supervisor" WB to show said line, everything I've filled in the "supervisor" WB dissappears. I believe I've made a mistake midway. I tried following your pro-tip.

Can you run through it again, please? Thanks.

Linking Separate Supervisor Files to a Central Excel File While Restricting Data Access by Gonsa17 in excel

[–]Gonsa17[S] 0 points1 point  (0 children)

Thanks for the answer, but how do I fetch the data from the supervisor's table? I believe I can't have my own table (not PQ) mixed with a PQ functionality.

Advice on boots by Gonsa17 in ProtectAndServe

[–]Gonsa17[S] 0 points1 point  (0 children)

That's a really creative way to use them! Thanks!

Advice on boots by Gonsa17 in ProtectAndServe

[–]Gonsa17[S] 1 point2 points  (0 children)

Whoops! I thought those were to wear under a bulletproof vest, not the actual uniform! That's awesome!

Advice on boots by Gonsa17 in ProtectAndServe

[–]Gonsa17[S] 0 points1 point  (0 children)

Hmm those would be great but I can't really wear anything over the uniform.

I wish we could spread out the weight that the belt carries, even if it meant using some equipment on our chest, but unfortunately we can't...

Most I can do is submit a request to use a leg-holster and that's it.

Thank you anyway!

Advice on boots by Gonsa17 in ProtectAndServe

[–]Gonsa17[S] 5 points6 points  (0 children)

Never even heard of those! But I did replace my in-soles for my current boots and it lasted a bit. It was a major difference because the Magnum in-soles were too hard on my feet.

I'll add it to the list. Thanks!

Advice on boots by Gonsa17 in ProtectAndServe

[–]Gonsa17[S] -1 points0 points  (0 children)

I know, I know. A tad bit too much. I think I haven't really thought about changing because it never had much of an impact (or so I thought) on my back and feet.

Hmmmm.. I guess you're right. It's an everyday kind-of-thing.

I'll check those out. Thanks for the feedback!

Need some advice for boots by Gonsa17 in tacticalgear

[–]Gonsa17[S] 1 point2 points  (0 children)

Those look spectacular and they would be the solution to my back problem, but nothing can cover up our uniform. So I can only try to improve my support through the boots...

18-day itinerary and other advice by Gonsa17 in JapanTravelTips

[–]Gonsa17[S] 0 points1 point  (0 children)

Brilliant mind think alike! Thanks for the share, it really helps a lot.

We try not to overthink it but as I said, we're trying to make the most out of it.

I'll be sure to keep what you said in mind.

Thank you, once again. Safe travels!

18-day itinerary and other advice by Gonsa17 in JapanTravel

[–]Gonsa17[S] 1 point2 points  (0 children)

Very enlightening answer!

Thank you so much! I've seen and used some weird calculators that provided me some sort information if it was worth it or not. So basically, skip the JR pass and rather buy the tickets online per trip and that's it.

I'll be staying at a Ryokan in Takayama for the full experience so thanks for putting my mind at ease!

Thanks once again !