hi all,
ok i'm stumped. Not at all sure how i can go about this really and don't have an idea of where to start looking for ideas, so please throw them at me if you think there's something i can implement...
here's my predicament -i run an Excel Workbook that tracks an assets whereabouts based on a user 'inventory' code. This 'user inventory code' is a 3-letter code and essentially provides an efficient means to identify a company/individual quickly. The workbook contains around 20-25 separate worksheets, each with 18 records. Each record records each register entry made (in the form of a register code e.g. ODI-123) and shows the date when an asset was issued out, to whom it was given (their user code and user title - e.g 'ABC' - Bob Smith), when it is due back and when it was returned.
What I need to look at is a report format that will trawl each of the WorkSheets in my WorkBook for items NOT received back yet (esentially any records without a 'Date Received Back' entry), and report them all on a newly created worksheet. In reporting the data onto the new worksheet, i require the 'Register entry number', 'User Code', 'User Title', 'Asset Type', 'Date Issued', 'Date Due' and 'Date Returned'. These are columns A-G
on my worksheet.
I've tried doing a PivotTable but keep getting errors saying "Cant open PivotTable sourcefile....". I've no idea what that means and a Google search doesn't really help.
Oh, and on the off chance its suggested i should have all the records on a single sheet, i'd love to. However, this is a 'fixed' company document and it's layout has been set by the directors and i can't change it - however much i'd like to, let alone how much sense it would make!!
can anybody suggest anything please??
ok i'm stumped. Not at all sure how i can go about this really and don't have an idea of where to start looking for ideas, so please throw them at me if you think there's something i can implement...
here's my predicament -i run an Excel Workbook that tracks an assets whereabouts based on a user 'inventory' code. This 'user inventory code' is a 3-letter code and essentially provides an efficient means to identify a company/individual quickly. The workbook contains around 20-25 separate worksheets, each with 18 records. Each record records each register entry made (in the form of a register code e.g. ODI-123) and shows the date when an asset was issued out, to whom it was given (their user code and user title - e.g 'ABC' - Bob Smith), when it is due back and when it was returned.
What I need to look at is a report format that will trawl each of the WorkSheets in my WorkBook for items NOT received back yet (esentially any records without a 'Date Received Back' entry), and report them all on a newly created worksheet. In reporting the data onto the new worksheet, i require the 'Register entry number', 'User Code', 'User Title', 'Asset Type', 'Date Issued', 'Date Due' and 'Date Returned'. These are columns A-G
on my worksheet.
I've tried doing a PivotTable but keep getting errors saying "Cant open PivotTable sourcefile....". I've no idea what that means and a Google search doesn't really help.
Oh, and on the off chance its suggested i should have all the records on a single sheet, i'd love to. However, this is a 'fixed' company document and it's layout has been set by the directors and i can't change it - however much i'd like to, let alone how much sense it would make!!
can anybody suggest anything please??
