I hope I am explaining this correctly. I am new to excel, and i just started
a new job. One department gives me what is called a line sheet which is made
in excel. From that line sheet I am to copy and paste certain rows to a new
spreadsheet and add columns that I need to perform my job. How can I create
a file that will automatically pull the information from the line sheet and
place it in columns I assign? I know there is a more efficient way to do
this. Any help you can give me will be appreciated.

This is the type of work typically performed using a macro (VBA code). If
the names of the two workbooks is always the same and the rows/columns in
both are always the same then recording a macro while doing it once (in your
running workbook, not the daily line sheets book(s)) can do it for you. But
I suspect that you have a varying number of rows each day and they may not
always be copied to the same location in your own book. That's where
customizing such code comes in.

To code up such a solution requires detailed information about the source
information layout (what sheet(s) are involved, what rows/columns) and
similar information about the destination workbook. It may be that source
column A data needs to go into destination book sheet in some other column.
Such column mapping has to be known also.


"Nai" wrote:

I hope I am explaining this correctly. I am new to excel, and i just started
a new job. One department gives me what is called a line sheet which is made
in excel. From that line sheet I am to copy and paste certain rows to a new
spreadsheet and add columns that I need to perform my job. How can I create
a file that will automatically pull the information from the line sheet and
place it in columns I assign? I know there is a more efficient way to do
this. Any help you can give me will be appreciated.