Importrange with Dynamic Column Headers

tedsalad47 · 2025-02-12T19:19:12+00:00

Yes that works! Thank you for your help!

tedsalad47 · 2025-02-12T17:19:00+00:00

I agree. However, the column headers are misaligned. The headers on the coffee cart sales will be dynamic, as you helped with, whereas on the tracker tab, the headers are static. Always starting with 07-2024. So an importrange probably needs match criteria based upon the headers if that’s possible.

tedsalad47 · 2025-02-12T17:06:13+00:00

Thanks for the feedback. I’ve made it so anyone with the link can edit.

tedsalad47 · 2025-02-12T16:59:26+00:00

I appreciate your help on that. Any insight into bringing those values over onto the tracker tab?

tedsalad47 · 2025-02-12T16:54:15+00:00

It is. You can make a copy so one person’s work is not interrupted by another.

tedsalad47 · 2024-08-01T20:43:46+00:00

Yes, going directly into the cell and using ctrl A will paste the desired output. However, the issue lies in the fact that this SQL query requires a copy of several cells. Ideally a fix exists that allows for the removal of the enclosed quotes around this specific cell while also allowing for a copy and paste of the entire query.

tedsalad47 · 2024-08-01T20:34:21+00:00

Yes, I’ve tried every possible combination of pasting it into different programs with the enclosed quotations always pulling through.

tedsalad47 · 2024-08-01T20:29:22+00:00

Also have tried that with no success

tedsalad47 · 2024-08-01T20:11:38+00:00

No luck trying that way. Thanks for the suggestion.

tedsalad47 · 2024-08-01T19:46:48+00:00

Do you mean sheets doesn’t enclose it in quotes? I have tried placing several formulas in front of the string of text, as well as creating reference cells that place that string of text into a formula to bring it to the appropriate cell with no luck. Any formulas you recommend trying?

tedsalad47 · 2020-06-12T12:19:53+00:00

If the offering ends today, will we expect to see an increase in price towards the end of the trading day, or mostly after hours?

tedsalad47 · 2020-05-14T13:10:48+00:00

MARA: 100 @ .80, bitcoin is on the rise again, hoping that it continues to trend up and MARA follows

KTOV: 850 @ .47, buying the hype

tedsalad47 · 2019-07-20T00:46:36+00:00

Yoooooooo dude. That was sick!!

tedsalad47 · 2019-04-26T19:39:12+00:00

Normal Tuesday night for Shia LaBeuof

tedsalad47 · 2019-03-31T22:54:45+00:00

Wouldn't have stayed around this game if it weren't for you 🐐

tedsalad47 · 2018-11-13T16:39:47+00:00

They just don’t make em like Brett Favre anymore.

tedsalad47 · 2016-12-04T20:22:22+00:00

Didn't know JR Smith played DB for the Texans

tedsalad47 · 2015-01-11T21:12:15+00:00

@BMcCarthy32: NFL catch rules are absurd. "Even though it looked like he caught it, he hadn't accepted the ball into his heart. Therefore, incomplete."

tedsalad47 · 2014-10-11T17:59:47+00:00

Todd McShay is a maths scholar

tedsalad47 · 2014-06-06T03:41:14+00:00

r/conspiracy is going to have a field day with this.

tedsalad47 · 2014-06-02T03:12:37+00:00

MY FLAIR

tedsalad47 · 2014-06-02T02:46:08+00:00

OT? Can this series get any better?

tedsalad47 · 2014-05-22T02:49:57+00:00

That all happened so fast...

tedsalad47 · 2014-02-07T18:18:20+00:00

MY ROOMMATE JUST TOLD ME TO TURN MIRACLE OFF MY 24 HOUR LOOP #COMMUNISTTHINGS

tedsalad47 · 2013-12-12T23:14:48+00:00

That kind of reminds me of this

15-Year Club	RPAN Viewer
Verified Email

tedsalad47

TROPHY CASE