Excel Forum - solved topics
- Solved
-
Macro Help Copy Specific Text from One cell into another Solved/Closed
Here is the scenario: I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or move...
-
EXCEL - Create a bulleted list in a single cell from a list Solved/Closed
Hello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...
-
Adding 1 to an existing number if criteria is matched? Solved/Closed
In column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...
-
Find the sum of data that has multiple conditions in Excel Solved/Closed
Hello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...
-
Error when creating mailmessage Solved/Closed
Hello, Using Excel and Outlook 2007 I want to create an emailmessage with a Macro. But I am running into an error I can not find any "comprehensi...
-
From Excel, Open a word document and goto a page question Solved/Closed
Hello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...
-
MAX value in one coulmn based upon another column Solved/Closed
Batch Price Column C 00015 2.75 00015 2.9995 00016 1.89 00017 0.56116 00018 0.1421 00018 0.11808 00018 0.1605 00018 0.12575 00018 0...
-
Highlighti Row/ colour fill through VB Solved/Closed
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...
-
Comparing Data in Excel Solved/Closed
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 ...
-
Re: Make a macro run when data entered in a cell -multiple event Solved/Closed
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", ...
-
conditional format Solved/Closed
Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...
-
convertion Number into word Solved/Closed
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 ...
-
40 % add formula in excel cell Solved/Closed
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...
-
INSERT ROW DATA INTO EVERY SECOND ROW Solved/Closed
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...
-
macro Solved/Closed
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...
-
Greater than/Less than between 2 Dates Solved/Closed
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...
-
Macro to highlight cells. Solved/Closed
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...
-
HELP ME WITH FORMULAS PLEASE? Solved/Closed
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...
-
creating an If function using dates Solved/Closed
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 ...
-
Unable to copy selected cells after apply autofilter function Solved/Closed
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...
-
Num Convert to text in Excel 2007 Solved/Closed
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...
-
VBA Code 2 import many cells not in range from many workbooks Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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/Closed
Hello, 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 Solved/Closed
Hi 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 Solved/Closed
Hi, 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/Closed
Hello, 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 Solved/Closed
Hello, 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? Solved/Closed
Hello, 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 Solved/Closed
I 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 Solved/Closed
hi, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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/Closed
Hello, 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... Solved/Closed
Hello, 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. Solved/Closed
Hello, 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) Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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/Closed
We 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello 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/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...