Consolidating Two Different Sheets into one.

0

Hi, I need a help. I have two data sheets one containing headers like INVOICE DATE, GSTNUMBER, INVOICENUMBER, INVOICE_DT, INVOICE_VALUE, TAX RATE, TAXABLE_VALUE, DEALER NAME & DEALER_ADDRESS, and another data sheet containing INVOICE DATE, INVOICENUMBER, INVOICE_VALUE, GST VALUE, BASICNONTTAX, CGST_TAXABLE VALUE_5, CGST AMOUNT 5%, SGST_TAXABLE VALUE_5, SGST AMOUNT 5%, CGST_TAXABLE VALUE_12, CGST AMOUNT 12%, SGST_TAXABLE VALUE_12, SGST AMOUNT 12%, CGST_TAXABLE VALUE_18, CGST AMOUNT 18%, SGST_TAXABLE VALUE_18, SGST AMOUNT 18%, CGST_TAXABLE VALUE_28, CGST AMOUNT 28%, SGST_TAXABLE VALUE_28, SGST AMOUNT 28%, DEALER NAME & DEALER_ADDRESS, GST NUMBER. Now I need to create a consolidated file like as the first one with only INVOICE DATE, GSTNUMBER, INVOICENUMBER, INVOICE_DT, INVOICE_VALUE, TAX RATE, TAXABLE_VALUE, DEALER NAME & DEALER_ADDRESS headers. The data is my business data and need the same in the specified format for filing GST return. Please Help.

I have also uploaded two excel files namely All data.xlsx and B2B.xls. Now I want the output data in the format of B2B.xls. Thanks in advance.

Answer
Discuss

Discussion

I have uploaded the excel files and the file named B2B.xls is in a seperate sheet in  All data.xlsx. Please help..
Avikkumar Feb 23, '18 at 7:08 am
Add to Discussion

Answers

0

This is a Q & A forum where you can learn Excel. To qualify for an answer you must ask a question, and to be relevant to this forum you must connect your question to teaching/learning Excel - however remotely. To help you on your way:-

  1. You have already created a list of columns you would like your output sheet to have. You should actually create that sheet because you need no help doing that.
  2. That action would lead you to your question almost automatically: how to transfer the existring data into the new sheet.

If you spend a little time on thinking about this question you will find ways to improve it. In particular, you don't want it to look like, "Who will do the work for me which I am too lazy (too busy) to do myself?"

You will find that there are two ways of transferring data, worksheet functions and VBA code. Think about the relevance of your question for this forum. If you decide that you need VBA but don't know VBA, buy a book and study. This isn't a forum to get free code written at no cost, and it isn't a forum for teaching VBA.

On the other hand, if you decide that the job can be done using worksheet formulas you will quickly find that you can actually write it yourself. The only difficulty will be to make it generic so that it can be used for all columns and all times. Now, at that moment you may not know how to proceed but you will fully qualify for an answer here because you have fulfilled the basic requirement of any student of any subject which is, you have understood the problem and seek for a way forward.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login