The discussions
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...
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...
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 ...
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...
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...
Vba code 2 import many cells not in range from many workbooks
SolvedHello, I have used some of your codes for importing data ranges from several workbooks. I am using Excel 2010. I have around 2,000 workbooks ...
Formula help
SolvedHello, I think this is a simple question just not for me :) I have a simple business spreadsheet showing total project cost in Column (C.) C, T...
Formula not working
SolvedHello, Q16 to Q20 cells contains values from 0 to 10 (it came from LOOKUP Function). I need to get a result in D24 from the cells Q16 to Q20 as ,"...
Import from multiple workbook to single sheet
SolvedHi, Thank for all your wonderfull help all these days, to cut short, I am looking for a VBAcode, which can import data from multiple Workbook file...
Comparing two columns of names in excel
Solved/ClosedHello, I have one excel sheet. column A has a list of names formated as follows: Last name, First name Column B has a much longer list o nam...
Spreadsheet data
SolvedHi everybody. I am trying to develop a large data input spreadsheet which will have circa 20 operators data input on a daily basis. (approx 150 ent...
Attendance sheet
SolvedHi, i want to make attendance sheet in Microsoft Excel 2007 with alphabetical words like P for Present, A for Absent, L for Late, H for Holiday wit...
Excel vba to open other screen
Solved/ClosedHello, We are working on dual screens. I am writing a macro program in VBA. I need to open an existing excel file/workbook in a new excel application...
How do i get excel file ( no formula) from another one ( with fo
SolvedHello, I have a big excel file with lots of formula and link. now can I export these data only( no link or formula) to another excel file? Thank yo...
How to check two fields in excel and act by that?
SolvedHello, Can anybody help? I would need very simple macro to check two cells. A1 will be name A2 A3 will be second namew A4 Does A2=A4 ...
Conditional formatting
SolvedI am trying to maintain three lines of accounting on one spreadsheet. Basically, I have an order amount (C3) . I want to take that total from one of...
Using a data validation and an if formula in the same cell
Solvedhi, I have a spreadsheet in excel 2010 where one of my columns uses a dropdown list using the 'data validation' function. The list details several ...
Different currencies
SolvedHello, could you please advise what could be the best way to show in the same table different currencies. Lets say there would be a button which w...
If function with dates
SolvedHello, I'm trying to compare cells with dates. For example: column A column B column C Mar-25 Apr-3 ? In column C I need a...
Pop up message stating empty cells
Solved/ClosedHello, I am relatively new to VB and I am trying to help a friend build an application form for work. Basically what I am trying to do is, there ...
Dates change when copying...
SolvedHello, Thanks to this kind of forum, I've been able to deal with issues around the date systems 1900 vs 1904. It remains a problem though since ...
I would like to compare 2 columns.
SolvedHello, I would like to compare 2 columns A to F, if the value is the same I would like to populate the value of column C with the value from Colum...
How to do an automation for copy paste, added new row (macro)
SolvedHello, I have attached file http://www.sendspace.com/file/wjh0oe I want to automated a some step (tab table Z) Thus, for example, that in X 201...
Formula help needed
SolvedHello, I am in need of a formula. I own a business in which I receive payments from my clients in various ways. I also have multiple locations...
Entering value for column at once, displaying in all sheets
SolvedHello, I have a workbook with multiple sheets(1,2,3) , each sheet has list of items randomly placed, the same items are repeated in other sheets ran...
Help combining worksheets in excel 2007
Solved/ClosedWe use excel 2007 to store information about our products and have a different worksheet for each range. Is there any way of combining all these wo...
Conditional formatting
SolvedHello, I need a help on Conditional formatting: I have a data in A2:E5 (Sheet 1), and in Sheet 2 i have reference data in Column A. i need to...
Inventory
SolvedHello, Can you pls help me with the following: I have Inventory Workbook, and Invoices. Every time I open new Invoice and entering Quantities of...
Vba how to create new worksheet and move value
SolvedHello there, I am zero in vba, can anyone please assist me what code to be used given following conditon Given,(I have data converted from csv t...
Excel macro; adding password
Solved/ClosedHello, Hope you anyone can help me with this... I need to create a macro that unlocks a password-protected sheet with password "password", do so...
Summing up data from groups & pasting it another column
SolvedHello there, I need to write a macro for the following example: A 2 A 3 A 3 B 4 B 1 B 4 C 7 D 3 D 8 Etc. Basicallly i ne...
Special sum of a column
SolvedHello, In have some columns with plenty of data. And I need to make a column which will have ... D2=C2 D3=C2+C3 D4=C2+C3+C4 ....................
Need help with percentage please
SolvedHello, I am new to excel and I am not very good at it so any help would be greatly appreciated. I know anyone out there is helping for no reason o...
Populate data in excel according with n
SolvedHello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...
Conditional formatting using dates in different cells
SolvedHello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...
Snding sms from excel sheet
SolvedHello, i need to send text message from excel sheet to mobile number. is there any method to send sms. please help me to give method. thanks ...
Dropdown lists in excel 2007
SolvedHello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...
Using vlookup to return insted of 00/01/1900
SolvedHello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...
Formula for between to dates
SolvedHello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...
One cell will turn green when the two other cells match
SolvedHello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...
=month(d2)
SolvedHello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...
Macro to email picking up email address in one cell using lookup
SolvedHi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...
Returning value from column b in column c, in a cell ajacent to
SolvedHello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...
Recovery my work and restart microsoft excel
Solved/ClosedHello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...
Compare data in seperate columns to find likely matches
SolvedHello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...
No tool bars or address bar on my browser
Solved/ClosedHello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...
Code for macro that conditionally inserts rows
SolvedHello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...
Excel for mac opens all files on desktop
Solved/ClosedHello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...
Can't open excel file
Solved/ClosedHello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...
