S
Sara Hopkins
Hi all,
I have a spreadsheet that is designed to be used as an Asset tracking tool.
It has an MS Query returning asset purchasing data like 'Item Description',
'Unit Price' etc. This data changes daily and the query is set to update
whenever the spreadsheet is opened. There are also columns within the
spreadsheet that are to be used for data that doesn't come from purchasing:
like Serial Number, Make, Model, etc.
My intention is to have the MSQuery data interspersed with the asset data.
However, whenever the data refreshed and new rows are added the asset data
doesn't move down the rows with it's purchasing data. I've tried all three
different "Number of Rows Changes" option in the Data Properties, but none of
them have helped.
I wonder if anyone has come across this before and knows the solution. I am
using Excel XP, have access to Excel 2003, but the end users need to run this
with 2000.
I have a spreadsheet that is designed to be used as an Asset tracking tool.
It has an MS Query returning asset purchasing data like 'Item Description',
'Unit Price' etc. This data changes daily and the query is set to update
whenever the spreadsheet is opened. There are also columns within the
spreadsheet that are to be used for data that doesn't come from purchasing:
like Serial Number, Make, Model, etc.
My intention is to have the MSQuery data interspersed with the asset data.
However, whenever the data refreshed and new rows are added the asset data
doesn't move down the rows with it's purchasing data. I've tried all three
different "Number of Rows Changes" option in the Data Properties, but none of
them have helped.
I wonder if anyone has come across this before and knows the solution. I am
using Excel XP, have access to Excel 2003, but the end users need to run this
with 2000.