Set up Ongoing copying from one sheet to another sheet in same workbook

[emdad16]

Hi All,

In my workbook there are two tabs, One of which contains raw data from a software and is very messy and the other contains neat sorted out data. I need for the data in the secon sheet to be automatically copied into the first sheet arranged into the collums I have set up.

The idea is that the data from the software will be ongoing and all I have to do is input the data into the messy sheet (perhaps by copy & pasting) and then the data should be sorted neatly into collums in the other tab.

Many Thanks All

[I didn't include my workbook as it contains personal info, however I basic workbook to try and test on]

[martindwilson]

that doesnt make it clear but one approach is...

[emdad16]

that doesnt make it clear but one approach is...

This is exactly what I was looking for.

Thanks

What is COUNT

[emdad16]

I really appreciate it. Could you kindly direct me to a website or PM about the formula. I am having difficulty digesting it from the example workbook.

[martindwilson]

use the help files! count counts the number of cells with a number in in this case its just finding out how many entries are on sheet 3

[emdad16]

use the help files! count counts the number of cells with a number in in this case its just finding out how many entries are on sheet 3

I did try Sir!. Not to worry I have found another way to do this. On last question when I used my method there is alot of empty rows. How do I configure excel to delete it automatically.

[martindwilson]

there are ways using an array formula but helper columns are usually more efficient and easier to understand

[emdad16]

How do you do it using the Helper Collum or Shall I make a new thread

[martindwilson]

see sheet 3 that's your helper column