Excel Forum
-
How to match 2 lists to get the unique entries [Closed]
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...
-
Calculate Formula based on values for two dates [Closed]
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 ...
-
Excel date format [Closed]
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...
-
Corrupted Excel and Word docs [Closed]
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 ...
-
Data from one file into running totals in another? [Closed]
Hi folks, I have two spreadsheet files. Both contain figures. One is updated daily and cleared daily. One is updated daily and maintained for...
-
How to pull text from column B if cell matches data in column A [Closed]
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...
-
Conditional Formatting Help [Closed]
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...
-
Combining rows [Closed]
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...
-
Conditional formatting based on range ofcells in different sheet [Closed]
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...
-
Replacing a value using lookup table [Closed]
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...
-
conditional graphbar colors [Closed]
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, ...
-
Copy specific cells to separate worksheets upon 2 conditions [Solved/Closed]
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...
-
Check if cells are blank or zero help please [Closed]
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 ...
-
Help creating an automated sheet [Closed]
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...
-
Change a value of a cell using look-up table [Closed]
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...
-
Based on date copy data and move total net down [Closed]
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...
-
change the cell color if the text in cell changes [Closed]
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 /...
-
give a text cell a percentage value [Closed]
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...
-
problem with macro [Solved/Closed]
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...
-
Search for a text in all the text files of a folder [Closed]
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 ...
-
Copy certain cells when an option is selected [Solved/Closed]
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...
-
I need help with conditional formating and VB [Closed]
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...
-
Multiple lines copy marco technic [Closed]
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...
-
Arrow key now working. [Solved/Closed]
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?
-
If function using dates in 2 cells [Closed]
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 ...
-
Data Comparison Between two excel. [Closed]
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...
-
single cell in my "work area" tab to be copied to a cell in the [Closed]
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...
-
date format [Solved/Closed]
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...
-
Excel - Copying from one sheet and writing to another file. [Closed]
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...
-
Help to insert a date using a macro in excel [Solved/Closed]
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...
-
Converting sub rows into sub columns [Closed]
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 ...
-
How develop Macros in Excel 2010 [Closed]
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
-
how to disable multiple instance [Closed]
Hello, this solution of checking "allow only one instance" did'nt work. please help me out Configuration: Windows 7 / Firefox 38.0
-
How to Hide and Unhide tabs according to cell criteria. [Solved/Closed]
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...
-
VBA [Closed]
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...
-
How to import a range of cells from a different worksheet [Closed]
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...
-
Data Consolidation [Closed]
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...
-
letters and numbers [Closed]
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...
-
convert number to word in excel [Closed]
Hello, please suggest me the way to convert number to word
-
How do I populate worksheet tabs via a formula or macros? [Closed]
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 ...
-
to consolidate data and copy to new workbook [Closed]
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...
-
Please help me to import name range using connection [Closed]
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...
-
Please help me to show these range from sheet name "output" [Closed]
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(...
-
Change yyyymmdd format to mm/dd/yy in excel [Closed]
Kindly give me guide to solve the change yyyymmdd format to mm/dd/yy in excel Santosh Mane
-
Excel VBA Format a Range Borders to Crossed diagonal lines [Solved/Closed]
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...
-
How can I pull Multiple information from a Data Sheet [Closed]
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...
-
change numeric to word in excel [Closed]
how to change numeric to word in excel
-
Copying conditional formatting to other rows automatically? [Closed]
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...
-
Macro to copy specific data [Closed]
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...
-
how to get multiple tables from sheet 1 and transfer to another [Closed]
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...
Subscribe To Our Newsletter!
