-
Hi, I am in need of expert help and as I was browsing the nest I came across this site, so I joined. Well I have created a work book which pulls out data from the schools database and populate separate worksheets. Now I have field titles such us 'Tutor Group', 'Gender', 'Ethnicity'...
-
My understanding of Excel is pretty basic so 1. forgive me if this isn't the right section and 2. I'm not exactly sure how to ask this question. I am a teacher and I have a grade sheet that has several projects' grading rubrics in columns A and B. Student names are then arranged in columns...
-
I have two workbooks on our network. One workbooks is our main one that we input data. The other workbook contains the summary. If I open the summary workbook I get #value in the field unless I open the other workbook then the field does the calculations. Can I open the summary workbook with out opening...
-
I'm new to the group today - My issue is a manager has used comments in excel 2007 for just that comments. Now the company is beginning to use Act for customer discussions and I want to export all his comments to import to a dbase. I can see that all comments in the print function have a cell reference...
-
Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
-
OS: Windows XP; MS Excel 2007 I need to update the "price" for a corresponding "Code". The updated Price is in a spreadsheet among as many as 15,000 "Codes" in a column and the corresponding "Price" is in another column in the same row. I need about 400 items updated...
-
In Excel you can make multiple selections in a spreadsheet by holding down "ctrl" while making selections, however normally Excel does not allow you to then copy these selections all at once and paste them elsewhere. I found a tip that suggests that this may in fact be possible using VBA (...
-
Dear Mr. Nick Hodge, Thanks for your reply. I am using Excel version 2002. I am a excel user (not programmer). What i am trying to do is extracting some stock data by web query. But in stead of repeatly creating new query for different stock, i thought this can be done by changing the query perimeter...
-
Could anyone please help me in query perimeter editing? A web query is successfully created in a excel worksheet. But then the 'edit query perimeter bottom' on the tool bar is not available to tick. How to make the bottom available to tick? or how can i edit the query perimeters? Thanks in advance...
-
1) could someone please advise whether microsoft query is a independence software? or where it is included in microsoft OS or excel.....? can i get it free? where? 2) How to create a formula in a cell with a varible for the workbook name? i.e. =[0003.xls]Sheet1!$A$1 which make the 0003.xls to be a varible...