User Profile
Rujinh
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
SergeiBaklan Okay, I have tried to follow your steps but it did not work so im not sure if I am doing something wrong. I have attached my screenshots for you to look at. Can you aslo let me know if my ribbons has everything I should have? Thank you!5.1KViews0likes2CommentsRe: Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
mathetes thank you for your help! I will try to do what you were mentioning as well and see what works better for me. I just wanted to find the easiest way to do this and be able to present it in a dashboard for a better visualization. SergeiBaklan could you walk me through so that I don't mess up what you were trying to explain to me? Both of your responses and ideas are great, I just need to try it out and see what works better for me. I do appreciate both of your assistance with this because its been giving me a headache trying to figure it out. I wouldn't say I'm in expert in excel but I just like to always learn more and find better ways to extract big data and provide a better visualization.5.1KViews0likes4CommentsRe: Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
SergeiBaklan My monthly sheets have the exact same information and structure each time. So if I have them in a separate folder and use file>from folder connector, can I continue to add months to it in the future and it still combine the data correctly?5.2KViews0likes1CommentRe: Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
mathetes Im so sorry for any confusion. I just really want to see the easiest way I can get this done. So let me just say what I do each time. Every month I have this data that I download from our help desk. I then want to try and make a better a visualization out of the data by creating a dashboard which I have shared with you in the previous posts. There are certain things I am trying to show as you probably saw. The reason why I created a column to calculate was because we want to see on average how many days it takes to complete a ticket, which is why I have those last 3 columns. 1. I see what you are saying here but I want to calculate the average days it takes to complete a ticket. 2. So you are just saying to copy and paste each time? I tried doing that in the past but it seems like too much to do each time. I have an original spreadsheet that contains data from August2018-July2020. So I created a table for each of those month and ran a Power Query to combine all those tables into one. Now my issue here is when I add another month to it, it sometimes messes up. When the combined data loads it will give me extra columns or some of the information is blank and im having to go back and enter it all in. 3. So I usually well add a new tab in my workbook and then go to my combined data tab to edit the query. When I do this, I combine the newest data but then like I said before it adds an extra column or will add blank information which I don't understand because the raw data has everything filled out already. 4. The screenshots I added in the previous post will show what I am talking about. Jumping to the end of your response: The steps you mentioned are correct. I turn that data into a table using the "Insert" toolbar. What's the "Query" that you run. Is that the Power Query you referred to in your first post, the one that "adds additional information that isn't even in your worksheets?" Once I have all my months added in separate tabs(worksheets) I go to data and where it says "New Query" I go to from other sources and select blank query. From there I put in my formula =Excel.CurrentWorkbook () and enter. When I do that it pulls every table in the work book. But when I do that, it sometime will load blank information. I know this may all seem confusing and I may be making it more difficult then it should be but I just don't know how else to do it.5.1KViews0likes6CommentsRe: Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
mathetes Thank you for your response, I have added my comments below. 1. Yes, I usually download this data for each month from our help desk and then once im done creating everything for it, I then try to combine all that data into one. 2. The monthly data layout is always the same. Like the column headers are the same. 3. That I am trying to figure out because when I add a new month it will add like a whole new column that messes up everything. 4. So the data is from August 2018- July 2018 and I add one every month that we come up across. The whole point of this spreadsheet is to see different trends from the data. So I am trying to create different PivotTables/Charts showing that data for easier data analysis as a whole. I already have one created and created a dashboard with all my Pivot Charts and have slicers but like I said, when I add additional months to it, it adds columns that aren't even in my tables. If I do use Access, could I create graphs showing all my data to see the different trends. I would like to create a dashboard like I already have. I'm not so good at Access as I've never really used it so I'm not sure what its capable of. You mentioned a VBA, how does that work? So basically, At the end of the month I will gather the data for that month and insert a table and when I go to run the query the newest table gets added to the combined data. I have attached some screenshots of what happens. I don't get why I keep getting blanks either because all the information is always filled out.5.2KViews0likes13CommentsHelp on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
Hi, I have this spreadsheet that I am working on and it contains multiple worksheets of data. I would like to combine all that data into one and create PivotTables out of them. I would also like to continue to keep adding additional worksheets and have it updated any time it is updated to the combined data. I tried doing this through Power Query but it never works. It always add additional information to my data that isn't even in my worksheets. Every month I have new data to add and it seems like every time I do this, it messes up my combined data when I run the query with the new worksheet.5.7KViews0likes15CommentsExcel PivotTable
I need help finding the best way to combine worksheets and creating a PivotTable from all the data. Also, every month I get a new report I download and add to this particular workbook but how can I get that newly added data to combine to my PivotTable I currently have. I've tried using the PivotTable and PivotChart Wizard but every time I want to add that new data, it gives me an error message. Please see my attachments to see what I mean. I would like to know an easy way where I can do this and continue to add data to my workbook without it messing up anything else.1.3KViews0likes4Comments
Recent Blog Articles
No content to show