Excel Forum
-
Copy the exact content from one cell using a formula [Closed]
Hi, I need to copy a cell into several other cells with the exact same data ie: D3 auto copy to D7, D11, D15, D19 and so on and on and on i...
-
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 ...
-
Writing Macros [Closed]
Hello, I am trying to find code that will let me add roles into my data base on a name and then sub-total that information. Please help... Thanks
-
Filtering with spaces between rows [Closed]
Hi All, Is there a way I can filter my column if there are spaces between rows? the spaces were put there for neat presentation purposes. :( thank...
-
Conditional Formating: Duplicate value in range of cells [Closed]
Hello: Using Excel 2010, I'm trying to set up conditional formatting to see if a particular value in column A2 is equal to a value listed anywhere ...
-
Lock only a few cells on a worksheet [Closed]
Hello, I have an excel file having many formula and I want to lock all the cells having formula. Whatsoever cell address, it could be D1, E9, J10,...
-
How to get multiple rows of info into one row [Closed]
Student schedules were sent to me on several lines (one line per class) so each student has from 5-7 rows of information. I want each student to have ...
-
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...
-
VBA Lookup [Closed]
Hello, I currently have a macro built that takes a value from a specific cell and looks against a lookup table in another work sheet. If the valu...
-
Nested IF Formulas with Times not caclulating correctly [Closed]
I have several start/end times and need to also calculate the difference in minutes of those times on occasion. START A END A ...
-
Formatting dates [Closed]
Help! I need to do a vlook-up between two workbooks with the date being the common between the two. The problem is that the date is formatted in a ...
-
Selecting columns in excel [Closed]
Hello, I tried to select a range of cells in excel 2010, using Range("A:H").Select But this selects the whole worksheet. I have tried different w...
-
How to convert number to word [Closed]
Hello, ow to fix it in excel always. I get it result only when apply it. but can not fixed. please how can I fixed (Permanently Save) in my computer...
-
"Remove Duplicates" macro gives error on protected worksheet [Closed]
Hello, Configuration: Windows 7 / Firefox 19.0 I have a macro that sorts and removes duplicates from a fixed selection in a single column. ...
-
Macro: Copy row to another header or sheet from a drop down [Closed]
Hello, I am creating a spreadsheet which contains a drop down list of categories. I am looking for a solution so when a category is selected it wi...
-
How To Compare data in Multiple Columns [Closed]
Hello, I have the below data in four columns 14 25 36 214 14 785 114 2563 I have to find out if any two value from the c...
-
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 ...
-
getting and error msg "The file you are trying to open "xxx.xls" [Closed]
Hi folks, getting and error msg "The file you are trying to open "xxxxx.xls" is in a differernt format than specified by the file extension. Verify...
-
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 ...
-
Need a macro which copy values from rows and paste into a table [Closed]
Hello, Actually I have a payroll in Excel. Each employee's salary detail is in a row. eg S# Name Basic Allo1 ...
-
Copy Row based on value of cell, and update row data back [Closed]
Hello, I have 3 sheets, "WHOLESALE", WEB SALES" & "ORDERS". If "WHOLESALE" or "WEBSALES" have a value "SPECIAL" in Column "A", it must copy th...
-
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...
-
Kindly Request for Excel Help in Cell Formating [Closed]
Hello, Configuration: Dell laptop with vista If you have some time, can you please try to help me, I would greatly appreciate any help ...
-
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...
-
Updating multiple sheets from a master sheet [Closed]
Hello, Please, how do I create a mapping between multiple sheets and a master sheet all in the same workbook? I have at least 400 sheets and ther...
-
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...
-
import files into excell 2003 from path [Closed]
Hello, I would like to import a long list of photos into a spread sheet using excell 2003 to make a product catalog. in column F I have the path t...
-
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...
-
use of formula [Closed]
Hello, l try to add up figures with vat but l coudn't get de total thanks. Configuration: Windows 7 / Firefox 19.0
-
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...
-
import photos from path [Closed]
I want to import a long list of photos into a spread sheet using excell 2003 to make a product catalog. in column F I have the path to the photo as:...
-
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...
-
have to update data from one sheet to other sheet automatically [Closed]
Hello, I have four excel sheets , in which some field names are similar. When i update a common field in one sheet i want other sheets to update ...
-
Format Range of Cells Based Off Another Range of Cells [Closed]
Hello, I have a set of values in column $A. I want to format cells in columns $B:$Z to be red if any of their values are equal to any values in co...
-
Excel, If / Then or is there a better way? [Closed]
Hello, I have a spreadsheet that lists each kid in my class. I have entered the answer they gave for each and every question on a 40 quesiton test....
-
Password Macro help [Closed]
Hello, I have a code that unlocks sheets I need to use that are password protected but I have other code I used to combine the worksheets into 1 w...
-
VB how execute code for each file open & open multiple files [Closed]
Hello, The top half is code for opening my file. I tried opening multiple which seems to open but not execute the code I want ran for each file. I'm...
-
Facing difficulties in implementing CHARTS [Closed]
I have file1, file2, file3 and I want to have a chart with each's G column from 2 to final and each's I column from 2 to final. G in X axes and I i...
-
Excel macro [Closed]
Hello, I need a help in using the excel macro I have designed the Userform for searching the particular value from the excel.By typing the valu...
-
Compare two columns in different sheet and retrive corrspo value [Closed]
Hello, How to compare two columns in one sheet with that of two columns in other sheet and retrive the corresponding Key value of the third column...
-
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 ....................
-
number to word [Closed]
Hello, i want to covert number in to word like 1000(one thousands) 100 (one hundred) Plz help me to convert number to word in this format Conf...
-
Comparing data in multiple excel worksheets [Closed]
Hello, For work, I was given an excel document with a different worksheet for each month in 2012. Clients can come to our food pantry one time in ...
-
Calculation of Time [Closed]
Hello friends Pls help me to calculate time in excel. Time value is A1 is 15:25. I have to subtract 11:30 hrs from A1 and doing calculation lik...
-
excel question nt answered by kioskea [Closed]
Hello, you have no answer of my question . Configuration: Windows 7 / Internet Explorer 9.0
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account