Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
HELP: VBA Code to extract data from an SQL Server database and put it into Access Database | Excel Programming | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming |