Excel Forum
-
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,...
-
How to use name range..Please help to solve this issue.. [Solved/Closed]
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...
-
Automatically Syncing Data from my master sheet to Individual Sh [Closed]
Hi, What would be the procedure for automatically Syncing Data from my master sheet to Individual Artist sheet. I basically would be enteri...
-
Excel Partial Cell Match [Closed]
Hello, I am doing a report of online tracking with automatic data generator raw data output format tracking ID / Views ...
-
comparison [Closed]
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...
-
Transpose every 4 rows [Closed]
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!
-
Need macro to copy paste from Sheet1 to Sheet2 with condition [Closed]
Hi Everyone, Please help to simplify below macro code. Sub Macro2() Sheets("Sheet1").Range("A2").Copy Sheets("Sheet2").Range("A2:A21") Sheet...
-
Macro:Combining related rows into one, but keeping some fields [Closed]
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...
-
How to change date in order of dd/mm/yy in excel 10 [Closed]
Hello, I want a solution for this!?! pls Configuration: iPhone / Safari 4.0
-
Please help! Excel Auto-Move Row to New Sheet [Closed]
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...
-
Help in Excel ignore blanks [Closed]
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 ...
-
what it mean RS = 7: Sheets(F1).Select [Closed]
Hello, im stater excel vba i see this code and im not clear what it mean please any one explain me.
-
Selecting Currency type [Closed]
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...
-
I have a excel sheet and i want same data to be copied in other [Closed]
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...
-
Filtering data from another worksheet cell value [Closed]
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...
-
Excel master list [Closed]
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...
-
Excel VBA input data to next empty Range [Closed]
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...
-
Exam layout help [Solved/Closed]
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...
-
Conditional formatting cell if every cell contains "YES" [Solved/Closed]
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...
-
VBA/Macro - copying rows onto new excel [Closed]
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,...
-
replacing any alphabet with C, and number with 0 in an alphanume [Closed]
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...
-
Excel help [Closed]
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...
-
Compare 2 Sheets -> Summary differences [Solved/Closed]
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 ...
-
Coding [Closed]
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...
-
Conditional Formatting for a particular column [Solved/Closed]
Hello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...
-
How to search for a value in a range if found run a procedure. [Solved/Closed]
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account