Excel Forum
-
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...
-
Is it possible to import namerange(values) from other pages [Closed]
Hello, i have 10 number of pages which has name like file1.. file2.. file3 to file 10 i have defined name range in all files.. i have another wo...
-
Having excel send an email when changes have been made [Closed]
Hello, I recently saw that a code was given to have an auto email sent out once the workbook was save. I tried the code but nothing happened for m...
-
its about excel macros [Closed]
Hello, I need to saveas some excel cell range as text file how to do it Any help will be appreciated Thanks in advance
-
Compare two excel sheets in the same workbook [Closed]
Guys ! I need your expert advise .I'm working on a crusie ship and at the moment I'm trying to compare 2 voyages (Passenger Lists) which has the same ...
-
Macros, button that copies data from certain cells into table [Closed]
Hello, I am trying to create a "database" table on one sheet to record data that was calculated on another sheet. The issue is the data calculated...
-
Copy data range from one Sheet to Another [Closed]
Hi, i try cope one Range for another Sheet in the Work book but I failed in the Past method and i dont find the problem Sub CopyClearedDefect() ...
-
How to copy conditional formatting to other rows? [Closed]
Hi folks, I have a problem. I want to color the whole row with conditional formatting. For example, if A1 = x, then the whole row from A1:Z1 should...
-
Conditional Formatting: 3 range of numbers [Solved/Closed]
Hello, would like to seek advice from some of the experts here. I want to do conditional formatting from column O6-O21. If percentage is a...
-
Master Sheet and Subsets [Closed]
Hello, I use Excel for keeping track of flights in a flight simulator. At the moment I have everything on a master sheet. There are 20 columns and ...
-
Reformatting a Date in Excel [Solved/Closed]
Hello, I could really use your help with Excel. How can I change a date formatted like this...03/12/2004...to just reflect the month and year...0...
-
Struggling with dependent text or list display in cell [Closed]
Hi - thanks for reading I'm not sure if this is possible but I'd like to get the following to work: - Cell A1 contains a small pick from list -...
-
Expiration Date Search, Copy to Sheet2 [Closed]
Hi! I have a spreadsheet with dates in column C starting at C7, and other info to do with the dates in columns A through L Im wanting to have a c...
-
Copy Data from One sheet in a workbook to another Sheet [Closed]
Hi, I'm trying to copy one sheet automatically in one workbook to multiple workbooks. For example the workbook is May 2015 Sales Numbers and the S...
-
get a percentage in microsoft excel [Solved/Closed]
Hello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Disabled Write Protection on a USB