-
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...
-
Hello everyone, I'd like to copy and transpose data from one sheet, where Column A is a SKU, B is the number of items in the SKU and each column is a different item number (can be up to 99 values) like the table below: 6KD-00001 7 2426.3 4617.01 4618.01 4619.01 4696 5065 5067 6KD-00005 8 2426.3 4629...
-
Hi Tenluv', The procedure is set for you below:It took 2 seconds to run. 1.create 2 sheets namely; sheet1,sheet2 2.Pate the data in sheet1 3.Save the code below as macro1: =========================================================================== Range("AA1:AC1").Select Selection.ClearContents...
-
hey I need help writing a macro that adds 2 values in a col. and then carries the total and keeps going to row 5000. The problem is the number of rows inbetween each number is always variable and the sum needs to return to the same position(if that cant be done results can be move to col B). For example...
-
Hello All, I have been trying to locate VBA code that will allow me to complete this scenario: A worksheet named "Data" has data in this range (A1:G1). Once the button (form control) is pressed the workbook is saved and then this needs to occur: The data on the worksheet named "Data"...