Hi
I have a report built in a BI app and I am exporting Data from it to excel.
When the Data is exported I would values in some Cells to appear slightly different.
My thoughts being that I create a new tab in the same workbook that pulls all Data from the exported excel sheet and displays it exactly the same apart from where I have highlighted the changes I need.
I have attached a document that will hopefully explain better.
Thank you
Please attach an .xlsx file, as you are working with Excel 2016.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You just need to set the formatting of those columns to DATE or DATE TIME as appropriate. What you are seeing are the date serial numbers because the cell formatting is currently GENERAL.
Sorry correct file type attached
Looking at the request on the Shipped sheet try the following on the Formula sheet:
1. Paste the following into cell H2 and copy down: =IF(ISNUMBER(K2),"Delivered",IF(ISNUMBER(J2),"Shipped",Shipped!H2))
2. Paste the following into cell K2 and copy down: =IF(ISNUMBER(Shipped!K2),Shipped!K2,"In Transit")
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks