- Jun 23, 2004
- 5,464
- 8
- 81
Not sure if this is best place for this, but got a couple pricing files for our company that we use to upload into our software.
Most recent update came from vendor differently. We spent a bunch of time literally fixing line-by-line to make as needed last year with similar problem but we don't want to waste all that time again.
I hate spreadsheets....(well, spreadsheet math & code....it's all non-intuitive insanity imho).......but I've been asked if I could help.
2 sheets but not exactly the same items in the exact same order. (close but not quite) I could just copy pricing from the new sheet to the old & recycle, but columns need to correlate so when we upload into our software, things don't get screwed up.
Suggestions??
TIA ~ Red
Most recent update came from vendor differently. We spent a bunch of time literally fixing line-by-line to make as needed last year with similar problem but we don't want to waste all that time again.
I hate spreadsheets....(well, spreadsheet math & code....it's all non-intuitive insanity imho).......but I've been asked if I could help.
2 sheets but not exactly the same items in the exact same order. (close but not quite) I could just copy pricing from the new sheet to the old & recycle, but columns need to correlate so when we upload into our software, things don't get screwed up.
Suggestions??
TIA ~ Red