Hi, I am new in excel. I have a template which need to be input by end user. Everyday I would need to copy paste to summarize and formula it into another sheet.
How can I transform the template into rows and columns? I am thinking to push into database, in future able to call from excel to retrieve data.
Or any other advise feel free to suggest. Thanks.
Cannot give any help based on what you've provided.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
To attach a workbook, “Go Advanced” and then scroll down to the “Manage Attachments” link. It should be self-explanatory after that.
Remember to desensitize the data.
Last edited by ChemistB; 04-08-2019 at 09:19 AM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi, I have attached Testing.xlsx
Input file with colour grey will be input by end user. Number will always change for adjustment.
Working file is the 2 different output I compiled. Can this be automated.
Easily accomplished with a Pivot Table. See attached.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Can it be automate? Or keep the data for pass year?
In future able to retrieve with parameter to get back to numbers?
Thats what I been doing for the pivot/manual copy paste.
I don't understand what you want. Perhaps you should manually mock up the solution you are looking for.
My suggestion would be to not allow the user to overwrite data. Set it up in tabular form with newest data points added to bottom and Sums calculated via pivot table or formulas on a separate sheet. The pivot table can easily be filtered to show any date range you are interested in or linked to a graph to show changes over time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks