I have data in a column on one sheet that needs to go into several rows in another sheet. Example: Column A has the following data (A1:A200): 1 2...
Hello, Do you know guys how it is possible to remove zeroes from an excel pivot when the field is not in the report filter but in row label. I have...
Hello, I am after a code which enables me to highlight/ colour code a row on basis of expiry date and update every time I open that exel file. f...
Dear all, Pls suggest for my following issue related to Microsoft Excel. I created a Report in Excel having many sheets. In all sheets, Subscrip...
Hi everyone, I would like to add a pop-up (like MsgBox) but I don't want the macro to wait for the user to click on any button. This mean a MsgBox sa...
Dear reader, I need to highlight a cell that contains more than 2 decimals. ex. 2,89 is good and should not be highlighted 2,899 is wrong a...
Hello, I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered ...
Hello, I want to put following 2 functions in single cell ROUND((C365*0.9144),2) CEILING((D365),0.05) Pls advise
Hello, I have a conditional formatting issue - and I think maybe the cause is that outcome is already a formula? In cell U5 I have the following...
Hello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...
Hello, have a sheet with following info A B C D E F G H I J date-sum-item percentage- date sum item now i need to match the date su...
I am trying to design a daily attendance sheet that students sign in on via computer, but I need it to also have a column that shows their attendance ...
Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...
I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered into any ce...
Within an entire excel sheet, I would like the entire row to turn into red font when I type the number 10 into any cell in column H. For example, ...
Dear All, I am new to excel coding. I need help regarding the below issue The below sub routine is the first sub routine. It gets the details fr...
I want to copy a formula using different data ranges. The formula can't take dynamic range once copied. Example I want to use sumif formula from...
Hi, In Excel, I have a column of data and corresponding flags (either 0 or 1) in another column. I want to copy only those data which correspond ...
Sir, How can convert Number into word in excel sheet. suppose there is 253900 in cell B2 in excel sheet. How can I convert this number as Two lakh ...
i want to increse 40% amount in my excel sheet and I have total quantity 90 can anyone like to tell me that how will I entre the 40% in excel cell tha...
Hi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way th...
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...
Okay now I need the column to say if the amount in c18 is 500.00 then put 20.00, but if c18 is 38.46 then put 38.46. When I enter the formula below, ...
Hi.. Please tell me how to find out matching two words with only one differnce. If Two Columns of Excel contains Data like Vehcile Numbers MH01A123 an...
i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or grea...
I am very new to VBA and have spent countless hours looking for help on the web. I have a worksheet with 100,000 rows(locations) and 34 columns(Cha...
Hi, I am not an expert in excel but have some experience. Could some find me some excel formula or VBA code preferably for my data: 01/03/2013 C...
Hi, I recently got some help to create a Macro to go into a series of workbooks saved in a certain forder to extract a range of information and creat...
Hello, XP, Excel 2002 I have a data sheet with a Line-gragh and scroll bars (up/down) The scroll bar shut increase/decrease a cell value. Done b...
Hi all, I need a set of 3 to 4 formulas which would show a monthly grow of accrued interest on each of the new amounts eg: formula 1:Month 1- 1...
Hello, I wonder if you can help me please? I have an excel 2003 document which requires more than 3 conditional formats, i am using this piece of...
Hello, I need to insert a multiple rows according to the count mentioned in column d. for example column A,B,C,D contains the data in Column D...
I have a invoice tracking spreadsheet, which I would like to update to highlight overdue payments in a new worksheet. I would like the spreadsheet to ...
Hello, I want to send email to list of users which are stored in Excel from A1 to A10. But if suppose if any of the cells from A1 to A10 is empty...
Hi, I found the below macro on another thread and used it successfully to insert pictures into Column A based on file names in Column B. Howeve...
Hello, I am working on patent data and now I need a macro to transform the text to table. There are 30267 patent and it cannot be done by hand. One...
Hello, I'm working on an extremely large catalog project where I'm basically taking one column of text and breaking it up into several different c...
Hello I am trying to formulate an if function, should the date in the cell be less than six months old from today's date the font is red, should the ...
Hello, I have about 100 sheets with different names in my excel document. I am trying to extract two numbers for each sheet into a summary sheet....
Hello i am having data in sheet one against date in column A1 and i want to paste date in sheet 2 against same date after this i want to change d...
Hi there My question basically boils down to payment / invoice match. In one column I have amounts (paid or invoice - often one payment will inclu...
Dear All, I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears. When...
Hello, Good day to all. I have this problem about supplying automatic spell number in writing checks. Actually, I already have seen so many ways ...
R/Sir, As per your instruction i have done how to num convert into words.But i have face a problem when i have writeen above 99999, than num co...
Hello, I am new to VBA. I have a problem which I believe is very simple, but I am failing foolishly. I have to generate a MsgBox warning the user t...
Hi, I have been researching trying to figure out how to do some data manipulation with VBA, I have been going nuts trying and failing at making this w...
Hi. Help needed please. I have a 2010 workbook which tracks income and expenditure, by month, for a small voluntary organisation. I want to be able...
Hello, I need help. I am a rookie to excel and I would like excel to send an email everytime there is a change made to the drop down cell of my ex...
Hello, Please tell me the formula that i want that days are automatic displayed when enter any specifica date. For example if i write in excel...
I want to create an =sumif query on a new tab, which looks at all 12 tabs in an annual accounts workbook, either month by month or all 12 months at on...