-
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...
-
I used Excel Explosion and created several files from my dataset. I selected the option to add alternate shading to every other line on the output. I've asked users to highlight changes that they've made to the file before sending back to me. The shaded cells won't allow a new fill color...
-
Hi everybody, I am working on a .net windows based project which deals with manipulating and managing excel worksheets using C# 2.0 . In this project the excel worksheets are being embedded and displayed on C# windows forms.I tried alot on displaying excel commandbar and toolbars but I am getting errors...