Appending data from one WB to another WB by date:

K

KR

I'm importing a very large csv file into a workbook (WB) where I'm condensing
the information down to 3 rows representing 1 day divided by 3 shifts (8hrs
each). I would like to take this daily data and append it to another WB by
date by copying and pasting value only. I have a header row and 3 data rows.
The 3 data rows start with the date. In the end I want the second WB to
contain several weeks worth of data.... Any help is appreciated!! Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose & reorg data from 2 WS to new WB 2
check Wb is open and copy data to it 10
Automatically sending multiple parts of text from one word doc to another - is possible. 0
append multiple worksheets data into a single multi-dimensional array 4
Formula to lookup data and enter it in another WB 0
Copy Cells from WB to WB 3
Copy and paste from WB to another WB 1
merge 3 workbooks (and all coniciding worksheets) into 1 master wb 0

Top