Unanswered

Excel functionality

(0) Share

Report

Posted on by dw22801

Hey everyone, PA newb here. Before I start putting in time to learn this, can anyone tell me if my problem could be solved with this? I have some spreadsheets that are emailed to me daily, and I have to combine them into one sheet. It needs typical reformatting, which I have macros for. But along with formatting, some of the data, has to be standardized into different words. I guess my idea is each sheet has to be downloaded, opened up, formatted, then moved into another sheet which standardizes the data with xlookups, then pasted into the final sheet. Does that make any sense? I can explain further if anyone would be willing to listen.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

PowerAppsWizard 388 on at

Like (0)

Report
Copy link

Link copied!

Hi
Will the data in excel be stored in tables?
If so, you could store the file in onedrive, query the tables and write the data to the common sheet (the data must be in a table).

Was this reply helpful? Yes No
dw22801 2 on at

Like (0)

Report
Copy link

Link copied!
Just to further explain. I deal with trucking oil. We use about 15 trucking companies to move oil for us. Every morning, each trucking company sends me a sheet showing the details of all truck loads that were moved the previous day. Those sheets are not actual tables. I then need to consolidate that data into one sheet. Unfortunately I can't paste them directly into that final sheet because the data from the truckers are not standardized. I have a helper book for that. It has one tab for each trucker. Each tab has two tables, the input and output. The output just lookups from a reference tab. There is then a tab with a power query that pulls from each individual output table. That is what I paste in my final sheet. My final sheet is also a table. I hope that makes sense.

Was this reply helpful? Yes No