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...
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...
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...
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. ...
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...
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...
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.
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...
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 ...
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
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...
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
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...
Hello, I want a macro for fill color alternative rows in excel selected table (only visible rows), anyone can you please help me.
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 ,"...
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...
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...
Hello, I was previously helped out with the following macro: https://ccm.net/forum/affich-689536-generate-excel-workbooks-based-on-excel-list ...
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...
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...
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. ...
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 of numbers from 1 to 10.
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...
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...
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...
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...
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...
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...
Hello, I'm using the following string in excel. =H2&";"&I2&";"&J2&";"&K2&";"&L2&";"&M2&";"&N2&";"&O2&";"&P2&";"&Q2 It will concatenate serveral ...
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 ...
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...
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...
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...
Hello, I have a spreadsheet which I am trying to summarise information from. We receive enquiries from many different properties we manage, and I'...
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...
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...
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...
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...
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...
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 ...
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
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...
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 ...
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,...
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 ...
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...
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...
I have several start/end times and need to also calculate the difference in minutes of those times on occasion. START A END A ...
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 ...