Excel Forum
-
How to insert result of =SUMIF on next free row [Closed]
I want to create an =sumif query on a new tab, which looks at all 12 tabs in an annual accounts workbook, either month by month or all 12 months at on...
-
Create new sheet,rename and allow duplicates numbering them sequ [Closed]
I have a workbook with 3 worksheets. 1) MENU 2) Arrears Report 3) NEW ACC and a button on the menu sheet with the following macro below The pro...
-
Sum a range of values only if it has certain value [Closed]
Hi, I need a formula to sum the values in a column but only for the cells in the next column that have a specific value. In my case I have range o...
-
looking for formula. [Closed]
hi looking for a formula to combine two worksheets in one both have 3 columns. if i copy the both worksheet in one than i have 6 columns like this. ...
-
while pasting the Un protected Cells became Protected an locked [Closed]
Hello, I made A excel work book called (Customer Daily balance) to be used by my Employees(users), this sheet is calculating the recent balance o...
-
Data Validation w/ Sum in Excel [Closed]
Hello All, I just found out about the drop down menu (Data Validation) feature, but I have a question in regard to it. I am trying to create a l...
-
Date format [Closed]
In Excel sheet i can't change date format. I tried to change usual. But nothing is happened. One format showing Standard. Please give the Solution.
-
Help on..Calculating number of weeks between week numbers.. [Closed]
Hello everyone, I would like some help please.. :) I would like to calculate the weeks between week numbers. i.e Start Date: 04/03/2013 Week 10...
-
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 ...
-
Change date format [Closed]
Hello, I want change date formula to "sep 10 2013" in 10-9-2013 plz give me detail Configuration: Windows XP / Internet Explorer 8.0
-
Excel Macro to insert the same 120 rows between 1000 unique rows [Closed]
Hello, I'm creating a product catalog database in Excel. I have 1000 unique product lines (rows). Each of those 1000 products is offered in 120 col...
-
how can I change date figure into english words [Closed]
Hello, i want to change a date written in figure in excel sheet in words. eg 6-4-2013 into Sixth april Two thousand thirteen please help me
-
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...
-
Macro for fill color alternative rows [Closed]
Hello, I want a macro for fill color alternative rows in excel selected table (only visible rows), anyone can you please help me.
-
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 ...
Subscribe To Our Newsletter!
