i forgot to post but this is up now

also claim

@gay

edit: if I start at line 23, it spits out the correct lines unless I enter too many items, where around 1/3 on the end gets corrupted. so, it's working enough!

sorry to be a nuisance, but I might be using it wrong?

as you can see, it likes to return information that's stilted (usually either returning quantities on the wrong lines or similar mistakes where the information is bumped up too many spaces, rendering the information inaccurate.) I've noticed that the mistakes depend on the line that the information is entered, and depending on which, different aspects will be affected, but haven't yet found the line that... works. I've been putting my information into line four, otherwise.

I'm fairly certain due to this error code it's because I might be accidentally picking more than one choice? apologies, I've tried a lot of different ways to not do that.


it looks like this when I paste:


I tried a bunch of different troubleshooting methods, so accidentally tampering with c3 is what I'm pretty sure I'm doing apologies.

@gay Hi, I went to use your parser and realized it is broken? I don't want to step on your toes, but it looks like resetting the sheet via File-> Version History to the start of October would basically fix it. You appear to have slowly built up REF errors in your data pull sheet, and at some point on October 17th that traveled into the early section of the sheet that inventory pasting actually fills. Then since the data columns that are already set with REF errors don't re-write with the proper inventory information, that's pushing all the output data off. Just removing the column A REF errors manually by blanking them should also fix it, provided whatever caused them in the first place doesn't happen again.

Like I said, I don't want to step on your toes or reset the sheet without giving you a chance to see what's going on, and I have no idea what initially caused the REF errors (nor do I want to poke around your codes more than necessary to get my backdated copy to work) but if you don't have time to figure it out yourself right now I wanted to let you know about a quick-fix

@wingsofwasp @Loki hi hi, so sorry for the late reply - my calendar is hell - i've restored the sheet to an older version!

i have no time to tamper or read through the suggested fixes (thank you!!!) w/ my schedule rn, but thank u for pinging me - i'll find some time to read through it hopefully next month, but for the meanwhile please just give me a ping if it decides to bork itself again

oh, no worries! thank you so much for taking your valuable time to do that

@gay hey sorry but the sheet doesn't seem to be working? i copy pasted everything into cell a4 like said and it didn't give me any result, not sure if im doing anything wrong