I have 3 worksheets that each contain columns of data I need copied onto a separate worksheet in the same book. I need to automate the process to avoid mistyping or copy/paste errors from one worksheet to the other. The same three worksheets are used for every project, but the number of entries in the columns change with each project.
Is there a way to copy the contents of all of the cells and only the cells that contain data, either text or a number to the new worksheet any time data is entered into the other three sheets?
An example to help clarify...
Sheet 1 - "Minerals"
Name Fraction Net Acres
John 1/2 80
Jane 1/2 80
Sheet 2 - "Leasehold"
Name Fraction Net Acres
CELP 1/1 160
Sheet 3 - "ORRI"
Name Fraction Net Acres
Gibson 1/160 1
Can I copy the contents of the cells under the column headers onto a "summary sheet" in a similar format as above when I have no idea how many rows might appear under each column?
Thanks in advance.
Is there a way to copy the contents of all of the cells and only the cells that contain data, either text or a number to the new worksheet any time data is entered into the other three sheets?
An example to help clarify...
Sheet 1 - "Minerals"
Name Fraction Net Acres
John 1/2 80
Jane 1/2 80
Sheet 2 - "Leasehold"
Name Fraction Net Acres
CELP 1/1 160
Sheet 3 - "ORRI"
Name Fraction Net Acres
Gibson 1/160 1
Can I copy the contents of the cells under the column headers onto a "summary sheet" in a similar format as above when I have no idea how many rows might appear under each column?
Thanks in advance.