-
Peter, Thanks for all the help, but I'm still running into a problem. I'm trying it out in a specific workbook rather than my personal, until I'm sure I can get it running okay. Okay, here's what I've done (apologies in advance; I don't see how to wrap my code): In a standard...
-
Hi, using excel 2010. I've build a simple bookkeeping model. Users are able to add new Gl-accounts (nr and subscription). If a new nr and or subscription is entered a warning will pop up (using conditional formatting). Nevertheless users can still add the account-nr (even if it already exists, ignoring...
-
Right I've now got another problem with this. I have an index of numbers that I need to filter so that the correct information is brought up at the same time. The index contains numbers that go up sequentially like so; 0001, 0002, 0003, 0004 etc and from time to time I will need to filter my table...
-
Hi, I'm fairly new to all this VBA side of ecxel and have gotten to a sticking point. I have a table of information that has several colums of data as shown below. The actual list is a lot longer than this! Document Type Document Number Document Issue Customer Name Copy Type Date of Input Input By...
-
I have a large table (many rows and columns, and the numbers of both change from time to time). I want to have a column - call it "highlight" - such that an 'x' in the column automatically changes the background color of the whole table row in which the 'x' appears to something...
-
Dear Friends, Good morning and Wishing you all a happy new year 2012. I have a query and i'm not sure with some simple method if there is a way out for my query. I have a data file in which i have the payout data for the month for all the service partners. Now is there a way out for me to seperate...
-
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 have written (and used for a number of years) a very controlling menu and stipulated multiple tasks with VBA. I have worked around it in 2007 using [alt][x] but am now finding this very time consuming and irritating (yes I AM old!!) It relates to a number of workbooks and worksheets and multiple changing...
-
Hi, I am looking for the VBA code that, when opening a certain file, excel automatically enables iterative calculation... (to overcome circular references which are there on purpose / couldn't avoid them) If possible: can you alse have Excel disable it again while closing the same file ? Thanks in...
-
I have built a dashboard type of excel tool that has data connections to 35 other excel files. The excel files are stored on a sharepoint site and users can go update the status of their task. I can use the refresh all and pull in updates. This has worked great for 3 years. This year I started running...