Excel: Concatenate Daily Recording

[Jeff]

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

 

[Guest]

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]

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









- 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

 

[Guest]

Jeff;

Why not try a "Down and Dirty" database. You can allow access to the owner
of the spreadsheets to them only. Import them into an Access database and
link them. When the spreadsheets are updated, the database will prompt for an
update. Update it everytime. You can drill down into whatever data you want.
The database can be set to read only. You will have to set up the tables so
that the spreadsheet will import directly to the appropriate table (which is
what a spreadsheet is). From there everything is pretty much automatic.
Search the help section in Access for "Linking Spreadseet". I've used it and
it works great. You can even set up interfaces for specific readers. Sales
for "Salespeople", Profit margins for "The Man", etc.

God Bless

Frank Pytel