excelcraze
Board Regular
- Joined
- Sep 10, 2012
- Messages
- 81
Hello Excel Experts,
I have an Excel file where I have got three sheets, let's call it Source, Result and Report. Source sheet contain lot of data in rows and columns, in Result sheet I have some array formula which brings up the result I wanted from the Source sheet. When I enter the key in Cell B7 in Result sheet it brings up the data I want from the Source sheet. It brings up all matches in rows and columns and each cell I have a control button which will copy the content in that particular cell. Everything works good enough.
Now, here is what I need. I have to create a report, for that, as I can't play with the data in Source sheet I have created another sheet called Report which will have same data which is there in the Source sheet. - If you now take a look at the sample file I have created I hope you it will help you understand easily - As I told you I have a control button in each cell in the result area which will copy the data in that particular cell (for other purpose I have created it) I want something else also to happen in behind. The data which is copied is to he highlighted in the Report sheet and in the next cell the date of that day to be inserted. If the same data copy on another day date should not be updated.
It's an immediate requirement, please help ASAP.
Thanks in advance.
I have an Excel file where I have got three sheets, let's call it Source, Result and Report. Source sheet contain lot of data in rows and columns, in Result sheet I have some array formula which brings up the result I wanted from the Source sheet. When I enter the key in Cell B7 in Result sheet it brings up the data I want from the Source sheet. It brings up all matches in rows and columns and each cell I have a control button which will copy the content in that particular cell. Everything works good enough.
Now, here is what I need. I have to create a report, for that, as I can't play with the data in Source sheet I have created another sheet called Report which will have same data which is there in the Source sheet. - If you now take a look at the sample file I have created I hope you it will help you understand easily - As I told you I have a control button in each cell in the result area which will copy the data in that particular cell (for other purpose I have created it) I want something else also to happen in behind. The data which is copied is to he highlighted in the Report sheet and in the next cell the date of that day to be inserted. If the same data copy on another day date should not be updated.
It's an immediate requirement, please help ASAP.
Thanks in advance.