Need to fix a bug

[raj00]

Hello experts need help to fix a bug in excel sheet I want master excel sheet which comprises of the result of the other tab of the same excel sheet.In master sheet the column A and column C is from result of the reamining sheets of the same file (sheet 1,2,3) of the same excel sheet in tab column A and coloumn G final result should be in the master excel sheet . I put the final result in master excel sheet I need the formula to reconcile the sheets.of other (sheet1,2,3...) please have a look.

Cross-posted at https://www.mrexcel.com/forum/excel-...cel-sheet.html --6SJ

[Logit]

.
You will receive an answer faster if you take time to change your description of the problem and what the expected outcome should be.
Understandably, you recognize the issue/s but ... your example workbook has duplicate data on all of the sheets with the exception of one sheet. It is
difficult at best to apply your description to the existing workbook provided for download.

You have referred to the sheets as tab A and a Master Sheet ... but neither exist in your example workbook by name.

- Condense your workbook to only three or four sheets.

- Provide a before and after example of what you begin with and what the expected outcome will be.

- Be certain the sheets are named as you intend for them to be when the problem is solved.

This should be a start to solving your request.

Thank you.

[raj00]

ok thanks i am changing it

[6StringJazzer]

raj00, there are two points I would like to raise. First, I am not going to open a file from an untrusted location. Please be aware that on Excel Forum you can attach your file to your post. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Second, your post does not comply with Rule 8 of our Forum Rules: Do not cross-post your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you must provide a link (copy the url from the address bar in your browser) to the cross-post.

I have edited your post to add the link but please follow this rule in the future.