Hi
I have a database that links to an excel sheet and displays all the records from a table and puts it into a set of specific cells.
I would like to set up a macro or query that would then remove all the records that i ahve just placed in to the excel sheet without removing any other cells
Say for example i have 9 records thta go into rows b2:b10, but in row b11 there is some data that i want to keep.
One more thing - the amount of records will change over time so really i need something to record the amount of records and remove that amount of cells.
i hope this makes sence
thanks
I have a database that links to an excel sheet and displays all the records from a table and puts it into a set of specific cells.
I would like to set up a macro or query that would then remove all the records that i ahve just placed in to the excel sheet without removing any other cells
Say for example i have 9 records thta go into rows b2:b10, but in row b11 there is some data that i want to keep.
One more thing - the amount of records will change over time so really i need something to record the amount of records and remove that amount of cells.
i hope this makes sence
thanks