help with database
 

Hi,

I get a daily data file from one of our systems that gives me transaction
status by region. The rows in the file represent the regions--Northeast,
West, South, Central. The columns contain the status--entered, completed,
error, in process, etc. Each cell gives me a count of the transactions in
that status, e.g. a count of 10 for West Error.

I'd like to set up a database so that I can track changes over time by
adding a "date" column to the worksheet. What stops this from being a simple
cut & paste operation is that if there aren't any items with a given status
that day then the column is eliminated from the data file.

If I have transactions for all the status types on a given day, the columns
in the worksheet would be: Date, Region, Entered, Completed, Error, In
Process

If no items were completed that day, the columns would be: Date, Region,
Entered, Error, In Process.

To add that day's transactions to the worksheet database I have to insert
cells to create a blank column, and that gets tedious.

Can anyone suggest a more efficent way to add each day's transactions to the
worksheet? I don't know if a macro is the answer but I thought I'd start here.

Thanks in advance,

David

help with database
 

Hey David,

I don't know much about data bases, but there are a few in this news
group that do. However, if you were to post your question in an
access news group there would be a lot more people with the expertise
you need who are willing to give you a helping hand.

I hope this helps you find your solution.

Best of luck,
-Minitman


On Mon, 25 Aug 2008 20:44:01 -0700, David3553
wrote:

Hi,

I get a daily data file from one of our systems that gives me transaction
status by region. The rows in the file represent the regions--Northeast,
West, South, Central. The columns contain the status--entered, completed,
error, in process, etc. Each cell gives me a count of the transactions in
that status, e.g. a count of 10 for West Error.

I'd like to set up a database so that I can track changes over time by
adding a "date" column to the worksheet. What stops this from being a simple
cut & paste operation is that if there aren't any items with a given status
that day then the column is eliminated from the data file.

If I have transactions for all the status types on a given day, the columns
in the worksheet would be: Date, Region, Entered, Completed, Error, In
Process

If no items were completed that day, the columns would be: Date, Region,
Entered, Error, In Process.

To add that day's transactions to the worksheet database I have to insert
cells to create a blank column, and that gets tedious.

Can anyone suggest a more efficent way to add each day's transactions to the
worksheet? I don't know if a macro is the answer but I thought I'd start here.

Thanks in advance,

David

help with database
 

Oops, I meant to say that I'm maintaining the data in Excel, not a database
program like Access. I just need to figure out a way to get the columns to
line up.

"Minitman" wrote:

Hey David,

I don't know much about data bases, but there are a few in this news
group that do. However, if you were to post your question in an
access news group there would be a lot more people with the expertise
you need who are willing to give you a helping hand.

I hope this helps you find your solution.

Best of luck,
-Minitman


On Mon, 25 Aug 2008 20:44:01 -0700, David3553
wrote:

Hi,

I get a daily data file from one of our systems that gives me transaction
status by region. The rows in the file represent the regions--Northeast,
West, South, Central. The columns contain the status--entered, completed,
error, in process, etc. Each cell gives me a count of the transactions in
that status, e.g. a count of 10 for West Error.

I'd like to set up a database so that I can track changes over time by
adding a "date" column to the worksheet. What stops this from being a simple
cut & paste operation is that if there aren't any items with a given status
that day then the column is eliminated from the data file.

If I have transactions for all the status types on a given day, the columns
in the worksheet would be: Date, Region, Entered, Completed, Error, In
Process

If no items were completed that day, the columns would be: Date, Region,
Entered, Error, In Process.

To add that day's transactions to the worksheet database I have to insert
cells to create a blank column, and that gets tedious.

Can anyone suggest a more efficent way to add each day's transactions to the
worksheet? I don't know if a macro is the answer but I thought I'd start here.

Thanks in advance,

David