The discussions
How to extract particular data's from sheet 1 into sheet 2
Hello I have three different columns in Sheet 1 with names Number, Step Description and Results. Each column have data's up to 100 rows. I want to ...
Transferring data from a column into several rows
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...
How to remove 0s from excel pivot (2010)
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...
Highlighti row/ colour fill through vb
SolvedHello, 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...
How to do in excel
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...
Vba - how to open a pop-up that does not stop the macro?
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...
Number of decimals in a conditional format
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...
Comparing data in excel
SolvedHello, 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 ...
Multiple functions in single cell
Hello, I want to put following 2 functions in single cell ROUND((C365*0.9144),2) CEILING((D365),0.05) Pls advise
Conditional formatting excel 2010 based on content in other cell
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...
Re: make a macro run when data entered in a cell -multiple event
SolvedHello, 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", ...
Compare columns match and insert data from another column
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...
Daily attendance sheet that calculates monthly percentage
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 ...
Conditional format
SolvedDear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...
Look at column and match and add this text te
Solved/ClosedHello, I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the ad...
Copying excel formula in different ranges
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...
Excel macro - selection of data from column using flag (0 or 1)
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 ...
Convertion number into word
SolvedSir, 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 ...
40 % add formula in excel cell
Solvedi 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...
Insert row data into every second row
SolvedHi 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...
Macro
SolvedSub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...
Incoming and outgoing mail servers
Solved/ClosedHello, I am having multiple email accounts. I like to configure all my email accounts in OUTLOOK EXPRESS. I am not able to do the same in OU...
Macro vba message run-time error '1040'/ i am getting this messa
I akeep getting error message any time a try to test the Ctrl code. Please help. b PrintChart() ' ' PrintChart Macro ' Created 5/7/2013. Macro...
Multiple if statement not returning numbers - returning words
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, ...
Graphic will only move up- all arrows nudge it up
After copying an image into word, I'll set it to be behind or in front of text and try to position it exactly where I want by clicking and dragging it...
Pdf won't open
Emailed attachment in PDF won't open in my windows XP. After double clicking the file it asks for ... tried all the selection (as I don't know what to...
How to find out two words matching with one additional number
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...
Greater than/less than between 2 dates
Solvedi 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...
Macro to highlight cells.
SolvedI 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...
Lookup/index data with multiple match
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...
Button to delete a row
Hello, i'm trying to create a comand button on excel to delete a slected row, using vb, i need to know the whole procedure and the code appreciat...
Ms excel found a problem and has to be finished
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...
Date change with column paste
Solved/ClosedHello, Whenever I try to paste the dates and times from one spreadsheet to another, the dates changes from 2008 to 2004. Why won't the dates just...
Help me with formulas please?
SolvedHi 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...
I want to put a date in b1 when i enter a1
Hello, I have a scanner that reads barcodes and when I read a barcode is there any way for it to put the date in B1 and the time in C1? I want ...
Conditional formatting vb
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...
Macro
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...
Excel macro to create new worksheet
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 ...
Inserting pictures into excel based on file name
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...
Searching and copying
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...
Replace charecter string with leading character
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...
Creating an if function using dates
SolvedHello 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 ...
Extract data from other spreadsheets in the same document
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....
Outlook 2007 using windows 7 home premium os ...
SolvedHello, I've not been able to SEND e-mails, only receive them. Outlook 2007 continues to try to send an item from the 'outbox' to no avail; then iss...
Unable to send email. outlook 10.
Hello, Suddenly unable to send emails from either of my two computers for two days now (Outlook 10). Sitting in my outbox and cannot get them to mov...
Sum numbers in a column by corresponding number
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...
Unable to copy selected cells after apply autofilter function
SolvedDear 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...
Spellnumber for excel
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 ...
Num convert to text in excel 2007
SolvedR/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...
Warn the user of empty cell and indicate the location based on v
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...
