I need the formula to get the cell data from Sheet1. My Input data is in sheet1 and i need copy the cell data in sheet2 as per the sheet2 format. attaching the sample data.
I need the formula to get the cell data from Sheet1. My Input data is in sheet1 and i need copy the cell data in sheet2 as per the sheet2 format. attaching the sample data.
Still using 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.
i am using office 365
Please update your forum profile NOW.
Thanks. There are NO expected results in your workbook - just an empty table. Please fill in some results manually to guide your helpers.
updated the sample expected output in sheet 2
Please Login or Register to view this content.
Last edited by JohnTopley; 02-04-2024 at 02:30 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Formula:Please Login or Register to view this content.
The solution is not working for actual data. Hence herewith i am attaching the original data. First sheet is about the fuel details date wise. I need the output as shown in second sheet with the
name of Details.
here except Date everything is dynamic. I mean Vehicle Number and Drivers names will be keep on change month by month.
Attaching the sample data sheet.
Paste the following into cell B3 on the Details sheet, then copy down and across:Formula:Please Login or Register to view this content.
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)
Bookmarks