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...
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...
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...
Hello, I need to saveas some excel cell range as text file how to do it Any help will be appreciated Thanks in advance
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 ...
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...
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() ...
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...
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...
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 ...
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...
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 -...
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...
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...
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,...
Hello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...
Hi, What would be the procedure for automatically Syncing Data from my master sheet to Individual Artist sheet. I basically would be enteri...
Hello, I am doing a report of online tracking with automatic data generator raw data output format tracking ID / Views ...
Hello, I have two spreadsheets with different quarters of the year however, the names changes because some are in the first quarter and not in the s...
Hello, I have a problem. How can I transpose this: 1 2 3 4 5 6 7 8 to this: 1 5 2 6 3 7 4 8 Help much appreciated!
Hi Everyone, Please help to simplify below macro code. Sub Macro2() Sheets("Sheet1").Range("A2").Copy Sheets("Sheet2").Range("A2:A21") Sheet...
Hello, I am referring to this resolution: https://ccm.net/faq/20104-excel-a-macro-to-combine-selected-rows What I need is is say each row of col...
Hello, I want a solution for this!?! pls Configuration: iPhone / Safari 4.0
Hello! I am stuck and could use some help please. I'm trying to make a dynamic spreadsheet workbook that has sheets based on project with a roll-u...
I wish to list out certain data from a source file. While listing in the new file, it should ignore blanks. How do I do it, please? Source File ...
Hello, im stater excel vba i see this code and im not clear what it mean please any one explain me.
while converting a numeric value to the words I wish to choose currency type like Dollar, AED etc. while using following article https://support.mic...
Hello, I have a excel sheet and i want same data to be copied in other folder. Other folder is my google drive so as i do the work i have a backup...
Hi I have a graph where I'm displaying some points from a worksheet, in this worksheet I have a simple autofilter filter criteria (Display = Yes or N...
Hello, I will be creating a spreadsheet with lots of text data, addresses, phone numbers, names, ect. I have all the data set up in rows so I will j...
HI everyone, I am excel vba stater I have crazy problem to solve. I want to input data into range j6 by use inputbox and if j6 had value next input wi...
Hello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...
Hello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...
HI I have Excel 2013. I have a file that I need to copy the rows onto a new excel workbook if it meet two criteria using VBA/Macro. For example,...
Hello, I have huge list of alphanumeric string in each row. And I want to replace any alphabet with C, and number with 0 in an alphanumeric. e.g I...
I think I need to use multiple formula to find this. I think an If function is used for sure. I need to find a formula that gives me the difference be...
For an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...
Hello, i want coding for excel to create multiple sheets for different row data in other sheet. Basically i have one input sheet, in which i enter...
Hello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...
Hello, I am trying to get my spread sheet to run a Macro I have that is working nicely (that copies the row and pastes it to another sheet in the ...
DON'T MISS