-
Hello all, I am very new to excel and I need help. Currently, I am writing a macro to populate results into a newly inserted column C (date and time) after I captured info from column A (dates) and column B (time) for a list of data that could easily go beyond thousands row of records. So far, I managed...
-
I currently have a formula (Below) that checks tolerances and determains if the number passes a criteria where V$2 is 0 and W$2 is 4. I would like to add an "If Blank" return True/Blank(havent decided yet) statement but cannot find a place to put it where it will work. =IF(OR((AND(V7*0.95<...
-
Hi. I need help with a type of counting problem. I have a huge excel data file with over 50,000 data entry points. It is forex data. I have a list of several banks. And their trade dates, and a bunch of other information columns that are cost, volume, what currency traded in, and more complicated diagnostic...
-
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 (...