User Profile
Hewtee
Copper Contributor
Joined Aug 22, 2020
User Widgets
Recent Discussions
Re: Updating existing sheet with new data from another workbook
Riny_van_Eekelen Ok thank you. Yes I also noticed no query!! I've attached my original workbook I was working on, but this one has no connections only queries 🙂 You will see that the query returns data from two other workbooks but duplicates the data. (I'm not sure if I mentioned but I get my data from MSForms and then download it as an Excel file, which contains all the previous data plus any new inputs to the form.) My query has a filter in it that picks up any spreadsheet from MSForms with a name starting with GrowthPredictorRankings.... (as the suffix changes in each download from MSForms So my main problem remains the duplication of the data Cheers Hugh62KViews0likes0CommentsRe: Updating existing sheet with new data from another workbook
Riny_van_Eekelen Morning. Ok I see what the problem is. Lets say my first Workbook that I load has 10 rows. The next one (later date) has 14. What the query does is add all the data into 24 rows and so its duplicating the common data from both workbooks. What I want is it to just "add" the new data. I have attached the file and a screenshot of power editor. I an concerned that I am abusing your kindness, if so I will post this question in the forum?62KViews0likes2CommentsRe: Updating existing sheet with new data from another workbook
Riny_van_Eekelen More' meneer (my attempt as I speak Afrikaans:) Ok I have got everything working thanks to you, however I selected combine files instead of merge. Is there a way to change the existing query or do I have to start again? Thanks Hugh62KViews0likes5CommentsUpdating existing sheet with new data from another workbook
Hi there all, forgive the newb query, I hope I make my problem clear. I am happy to share the Workbooks I am referring to 🙂 I have 2 workbooks that I need to link to each other so that new data in (1) updates data in (2) automatically. I have questions to do with each. Workbook 1. Rawdata.xlsx. Data source is MS Forms (Preview/Free Version) and using the "download Excel" option. The name suffix changes with each download eg: Rawdata (1-14) and next will be Rawdata (1-21) etc (Each of these is downloaded to a separate folder) Question 1. Is there to deal with name suffix change, apart from renaming each downloaded worksheet? seems clumsy to me, I'm hoping for an easier way. Workbook 2. Analysis.xlsx The first tab "DATA" contains filtered data sourced from Rawdata.xlsx . The rest of the tabs source their data Tables from the DATA tab. Question 2. My problem apart from Question 1 is that I cannot get the data from Rawdata.xlsx to update the DATA tab The flow therefore is : MSForms Excel download - Rawdata.xlsx - Analysis.xlsx Data Tab - Analysis.xlsx to other tabs Thanks HughSolved64KViews0likes10Comments
Recent Blog Articles
No content to show