Excel Forum
-
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...
-
Compare 2 sheets [Closed]
Hi, I have two excel sheets that i need to compare. The problem is that the column headers of sheet 1 doesn't match with the column headers of shee...
-
Macro to delete a certain worksheet... [Closed]
Hello, I was previously helped out with the following macro: https://ccm.net/forum/affich-689536-generate-excel-workbooks-based-on-excel-list ...
-
How to get the last digit of a value of a cell to other in VBA ? [Closed]
Hello, I am trying with vba excel that how to get the last digit of a value in one cell to other.suppose I am trying to the get last digit of 9928...
-
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...
-
Need help with Excel Formula [Closed]
I am having trouble figuring out a formula when figuring angles. I will write what I need (very simply) so you understand what I am trying to do. ...
-
Get excel 2010 to send auto e-mail [Closed]
Hello, I have a spreadsheet that i track my vendors certificate of insuranse expiration dates on. i am wanting excel to send me an automatic e-mai...
-
What is the shortcut key to drag down in excel to create series [Closed]
What is the shortcut key to drag down in excel to create series of numbers from 1 to 10.
-
Issue with V-lookup and possibly pasting data from the web? [Closed]
Hi, I'm hoping someone can help me. Using windows 2010, I'm using data from 500 alphanumeric codes that I copied-and-pasted from the net into a pr...
-
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...
-
finding values from 2 worksheets where item matches [Closed]
Hi, I have just start my new role where I am stuck some where I have got 1 Order form where SUPLIER NAME|SUPPLIER CODE |SUPLIER ITEM CODE|REF N...
-
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...
-
Exclude "0" values from string: =H2&";"&I2&" [Closed]
Hello, I'm using the following string in excel. =H2&";"&I2&";"&J2&";"&K2&";"&L2&";"&M2&";"&N2&";"&O2&";"&P2&";"&Q2 It will concatenate serveral ...
-
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 ...
-
using IF for data validation [Closed]
Would like to seek your assistance. I trying to make a condition using data validation. this is the scenario: for column C8 (this is the dropdown l...
-
Conditional formatting in Excel 2003(more than 3) [Closed]
Hello all, Excel 2003 novice here trying to teach myself. I am trying to make some fields turn a certain colour depending on the number of...
-
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...
-
Count when a range of cells contains a certain word or phrase [Closed]
Hello, I have a spreadsheet which I am trying to summarise information from. We receive enquiries from many different properties we manage, and I'...
-
Copy data from one WB to another [Closed]
Hello. I'm hoping I can describe my problem/question in a way that makes sense... Here goes: At my work, we have a program that will create an exce...
-
Macro for inserting missing monthly rows [Closed]
Hello, Can someone please help me with writing up a macro which inserts rows, which contain missing monthly dates within a data set? I basicall...
-
Copy data from one workbook to other----Help [Closed]
Write macro to copy data from Source File to assignment-2 file. Make sure you take care of following conditions * Book with same name should...
-
Pivot Table [Closed]
Hello Friends, I have 3 concerns related to Microsoft Excel which are as following. Pls help me for all these 3 individually.: 1. Suggest me...
-
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- How to Install a VPN
- How to Upload High Quality Photos to Instagram
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- Facebook Code Not Received
- Computer Boots to Black Screen