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 ...
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...
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...
Hello, Configuration: Windows 7 / Firefox 19.0 I have a macro that sorts and removes duplicates from a fixed selection in a single column. ...
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...
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...
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...
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 ...
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...
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 ...
Hello, Actually I have a payroll in Excel. Each employee's salary detail is in a row. eg S# Name Basic Allo1 ...
Hello, I have 3 sheets, "WHOLESALE", WEB SALES" & "ORDERS". If "WHOLESALE" or "WEBSALES" have a value "SPECIAL" in Column "A", it must copy th...
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...
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...
Hello, Configuration: Dell laptop with vista If you have some time, can you please try to help me, I would greatly appreciate any help ...
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...
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...
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...
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...
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...
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...
Hello, l try to add up figures with vat but l coudn't get de total thanks. Configuration: Windows 7 / Firefox 19.0
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...
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:...
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...
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 ...
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...
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....
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...
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...
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...
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...
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...
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...
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...
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 ....................
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...
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 ...
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...
Hello, you have no answer of my question . Configuration: Windows 7 / Internet Explorer 9.0
DON'T MISS