I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the en...
Hello, I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value ...
Hello, I take care of a list in excel 2013, in which a group of people continuously feeds data (a sort of archive). One column expects dates in a ce...
Hello, I recently bought a new laptop pre-loaded with W8.1. I downloaded MS Office 2007 Home and Student (it was a 3 licence package and this was the ...
Hi folks, I have two spreadsheet files. Both contain figures. One is updated daily and cleared daily. One is updated daily and maintained for...
I want my form to know which employee is assigned to the county listed on the form. Basically, if cell F5 says Multnomah, I want the formula to look a...
Hello, I have a spreadsheet which we use for tracking all outgoing shipments. I have the expected delivery date in one column, and the actual deli...
Hello, My situation is similar to a question that was asked but not exactly the same. This is how my spreadsheet looks now: A 1 1 0 0 1 1 A 0...
Hi, I'm trying to make the conditional formatting based on as follows: cell in sheet 2 is getting red if anywhere in sheets 1,2 and 3 could be f...
Hello, I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Shee...
Hello, I am trying to create a chart where column B depicts numbers for 2014 and Column c for 2015. 2014 is a line graph and 2015 is a bar graph, ...
Hello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...
I have a spreadsheet where columns A and B will either contain numbers or be blank. I need to add a formula into column C (for example cell C2 which ...
I need to create an excel sheet that will automatically search information on a "raw data" sheet and give results on a different sheet "sheet 1". I w...
I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Sheet 2 w...
How to move total net etc down based on the data filled above based on date If guest stay 2nd night second night data must me filled below first...
Hello, How do I conditionally format in excel (i.e. change the cell color if the text in cell changes?) Thanks, JC Configuration: Windows 7 /...
hello everyone; i am doing an evaluation report (checklist) and the output will be used as values for evaluate the service itself, soi created a sele...
Hello, I have problem with macro. if I delet on of the samples data, the 4 parameters value (a,b,c ,d)will change while is 4 parameters based on the...
I have about 200 text files with different names that gets stored in a folder. What I want is when a specific word is found (ex error, fault). I want ...
Hello, Can anyone help me with a script to: Copy: cell A, Worksheet One to cell B, Worksheet Two; cell G, Worksheet One to cell D, Worksheet Tw...
OK so i have been trying to figure this out for a while and I am stumped. I have 2 columns 1 collum will have either M,Q,Y,S in them. these will no...
Hello, I have a little complex excel work to be done in my office. I will explain you below. It would be very great help if it clicks in your mind...
Hi, When i use the arrow keys using excel, the columns & Rows are being highlighted. How to unlock this? Can you help me to solve this?
Hello, I am trying to format a cell using the iF function for dates in 2 cells. Eg If the date is equal to or less than Jan1st in B2 and Greater ...
Hello, I have a situation where I need to compare data resulted from two SQL's ( Source & Target ). Need a macro to validate the differences and hig...
Hello, I believe this is somewhat easy/straightforward but I don't know how to handle. I have a work book with multiple tabs. One of the tabs (spr...
Hello, I want to write date into following format like (25/05/2015) into 25 days 05 months 2015 year. Is it possible??? Thanks Configuration...
I have a form created in excel where the user enters customer information such as Name, Address, Phone #, etc. I need the info to be copied and wri...
Hello, I have a spread sheet with four tabs. I have written a macro to copy the tabs and rename them but I need to be able change the date which u...
Hello, I have consolidated data in excel, except I need to change the layout it is displayed as. Is there a way to change this layout or to write ...
Hi, I want to consolidate the excel files from the common location. Can anyone help me how this can be done through excel macro. Thanks
Hello, this solution of checking "allow only one instance" did'nt work. please help me out Configuration: Windows 7 / Firefox 38.0
Hello, I have an Invoice that has a Rent To Own Sheet and also an Order Form attached to it. On my the Order Form tab I have a data validation...
Hello. Asking for anyone who could please help me. I am an Environmental Science major with only one basic computer class from 2001. I have 2 major pr...
Hello, Please help me to import a range of cells depend on the output cells generated on different worksheets on a page-2(in my folder the differe...
Hi Team I have a set of data in Sheet 1 ( Data vs value ) . I want to consolidate the value according to its data in the same sheet. This can be d...
Hello, Could someone please help. Is there a formula to convert A12812001 into 5/8/2015. A =2015 and 128 = the day. The rest of the numbers do...
Hello, please suggest me the way to convert number to word
Hello, I have a list of fifty different names I need to enter on the tabs of 50 worksheets (all on the same workbook). Is there a macros formula ...
I have a workbook "EOLPN_Data.xlsx" with 22 sheets on it, data and sheets will increase every month. I want to create a new workbook and copy all the...
Hello, i have connected a worksheet-2 to worksheet-1 and in worksheet-2 i have named ranges which i want to import using the vba script is it poss...
i have a sheet name output in my worksheet.. i want i, j to show the path or range from "output" page. please help me to solve this issue. Sub Max(...
Kindly give me guide to solve the change yyyymmdd format to mm/dd/yy in excel Santosh Mane
Hello, please help me to format a range of cells like if in a range a1:c10 if any cell eg: c1 contains a value c then format diagonal lines wit...
Hello, I have a data sheet with hundreds of Packaged Products that have specific items in each one, and what I am trying to do is on another sh...
how to change numeric to word in excel
Hi folks, Could somebody good with excel please have a look: I have a problem. I want to color the whole row with conditional formatting. For e...
Hi, I have the following script which copies data in cell A in the row where "Y" is clicked in column 26 from worksheet One to cell A in the next b...
Hello, i am trying to transfer data from one sheet to another. i have drivers so i want each initial to have its own table. can someone help me with t...