Search results for query: *

Hi I'm very new to coding and was wondering how i could import 1 csv file into my excel workbook but for every different item in the csv file generate a new worksheet for each instance please so for example the csv file contains Header1 Header2 A 10 B 10 C 10 A...

Hi I have two tables, one with employee data, [Name], [EmployeeID]. A second with [EmployeeID],[ROWID],[NOTES] I'm trying to return all Notes from the second table into a query with the first table where [ROWID] equals 1 or 2 but laid out in single rows [TABLE1]![Name], [TABLE2]![NOTES] AS...

Hi I have a excel list box which i made from a vba manual, however i have to open this spreadsheet via the internet explorer browser and am getting a debug error of Method 'Range' of object'_Global' failed My code is and its highlighting the the Range line ???? Private Sub cmdOk_Click()...

Hi Very new to vba but i've created a spreadsheet which has several links to hidden sheets in the workbook and a text book vb list box select going on. The problem is when i try and run this spreadsheet from a web page hyperlink it fails to find the hidden sheets. I get the error Run-time...

Hi i have a series of data which needs to be put into a graph, the problem i have is that i do not want the min value (Y) axis scale to be set to 0 or auto and a number i type into the format axis properties, i need it to look at the lowest value in my table and set it to another value...

Hi, is there anyway i can take a sheet of data in excel and then export certain rows matching a specific criteria into a new workbook? For example i would want to take all of the A's and put them into an a workbook or a workbook template and the b's into a b workbook etc etc However the...

Hi I have an access 97 database which uses a form to collect either a yes or a no answer and then stores it in a table. The problem is i need to be able to run either query 1 if the response in the table is yes or query 2 if the response is no, using a button on another form (its needs to...

Hi I have a table of data which could increase in size or decrease each time i need it but the ID column ($A:$A) may be missing a value. The problem is that i need to be able to look down this range up to where ever the grand total row cell reference sits and find blank cells and insert the...