Search results

  1. S

    Copy data from one Excel sheet to another but on if data in to columns match

    Hello, I'm sure this a job for an Excel macro but I'm a newbie and have tried loads of methods to get this to work. I have two sheets of data Sheet1 is the master with Columns A to O populated. Sheet2 has 5 Columns of data A to E, Column A of this sheet holds the same data as Column E in...
  2. S

    Export query results and overwrite existing xls file data

    I have an xls file with macros embedded that needs updating on a daily basis. The data I need to update this sheet is in an Access database table. I have created a select query to obtain the correct data to be exported but that's about my limit. It would be a great help if somebody could...
  3. S

    Union query results in seperate columns

    Hi Forum, I'm a newbie to Access and have been thrown in at the deep end to gather information from multiple tables and export that data into excel. If I could have some help to solve this first problem I think the rest will be straight forward. Fingers crossed. First problem then..... I...
Back
Top Bottom