Excel: Concatenate Daily Recording
On Sep 1, 4:38 pm, Frank Pytel
wrote:
Jeff;
Why not create the information in a new workbook. Copy the worksheet to the
workbook that you wish to use. Date that work sheet to have for back up. If
it's not to much data, highlight copy and paste into the worksheet that you
are calculating data from?
God Bless
Frank Pytel
"Jeff" wrote:
Our point of sales software (POS) has the ability to import
information into Excel and we wish to pull data from this workbook
(#1) (which is a dynamic document we write over the type of everyday
for the previous day's sales) into a seperate tracking sheet type
Excel workbook (#2).
We wish to do this on a daily basis and are experiencing challenges in
writing a formula that will not write over the top of the imported
data from the day before. In other words, if we imported Sept. 1st
sales into our #2 Excel workbook from the POS system's #1 Excel
workbook & then the next day we wish to repeat the process for Sept.
2nd sales... How do we not write over the previous day's data?
We want to know how we write formulas that will start over on the next
line after the previous day's recording (which was based off of the
same dynamic source, the #1 workbook which is the exported from the
POS system).
Thanks so much!
Jeff- Hide quoted text -
- Show quoted text -
Frank,
Thanks so much for taking the time to respond to my post!
Unfortunately you suggestion is exactly what we want to avoid doing as
there are several opportunities in that type of process for error. As
explained, this is to be a more automated process under which one can
open any one of our 8 product sales tracking spreadsheets and the
information will simply import in from the source.
We simply want to know how we can have a body of formulas begin fresh
in a new series after that day's import is finished. Again the idea
is to not write over the top of the previous days recording but have
our body of equations begin anew pulling from the first line of our
source workbook.
Thanks,
Jeff
|