Excel Forum
-
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.off...
-
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 ...
-
Find Closes Data Match [Closed]
Hello, I am hoping that someone could give me some support, and any efforts would be greatly appreciated. I am looking for the some help doing...
-
change the date format in excel 2007 worksheet [Closed]
Hello, i want to know that howcan i change the date format in excel 2007 worksheet if i want it like :- yyyy/mm/dd regards, Amol. ...
-
finding a date (N30) in a date range B5:B30 and returning A3text [Solved/Closed]
Hello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...
-
Removing False Word in Excel [Closed]
Hello! How to remove the false word in this formula and retain only the amount instead? =IF(O50,VALUE(M5)) Thanks!
-
Finding Closest Data Match [Closed]
I am looking for the some help doing the following. Assume each cell in Column B is the target cell, and the data in Column A is to be interigated...
-
After Pushing Command Button on Sheet1, Sheet 2 Auto. opens up. [Closed]
Hello, I have created a workbook with several pages of Information. One of the pages sheet2 ("Order Form") will figure information. There is a ...
-
Counting the number of Times a Cell changes colors and Archive [Closed]
Hello, Hello, I would like to count the number of times a cell goes green and archive it. How can I do this? Thank you for any help you can give. ...
-
Auto. copy a row of data onto another sheet using conditions [Solved/Closed]
Hello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...
-
Auto populating multiple sheets [Closed]
Hello, I have read some of the Qs and As and they are scary if you don;t know Excel. ! Is there not a simple formula for entering data into a sp...
-
macros to copy conditional data [Closed]
Hello, I am beginner in macros and am trying a macro code which does the following. I have 2 sheets by name sheet1 and sheet2, sheet1 consists of...
-
Amexxx1 [Closed]
Hello, I don't seem to be able to run this simple code; I copy and paste but when trying to run in my General tab by pressing alt+F8, no macro is ...
-
Macro to Search for a word and put a code on the cell next to it [Solved/Closed]
Hello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...
-
Count if Based on Cell Color & Date Range in a Column [Closed]
Hello, Any help on this would be greatly appreciated. I am trying to build a macro. That would look at a start date and end date manually entered...
-
Automated Data Insertion [Closed]
Hello, I'm glad I have found this forum. On generic spreadsheets I can maneuver fairly well, but I believe I have stepped off a steep ledge here....
-
Macro which can be calculated every month Rent [Closed]
I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are differ...
-
VBA that Copies/Paste rows based on Amount [Closed]
Hello, I have a spreadsheet that has our products. After the product is chosen then there are hundreds of options to choose from. I hav...
-
search functionality,copy and paste [Closed]
Hello, I am new to VBA and looking for a search functionality macro.I am looking for three steps;- There are three sheets,in sheet one i just cre...
-
Push data to new table [Closed]
Hello Everybody! I am trying to build a tool for our Company which helps plan future collection and eventually should turn into a Gantt. So... i...
-
if cell contains [Closed]
Hello sir, Actually I wanted to know is there any formula if column contain description like - qty box size 1kg - ...
-
Exam Layout [Closed]
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 start? I h...
-
How do I count the number of times a cell changes color [Closed]
Hello, I would like to count the number of times a cell goes green and archive it. How can I do this?
-
Send data from Raw Data sheet to numerous Specific sheets [Closed]
Hello, Trying to make a document in whcih my laboratory can track the reagents coming in. I have a source sheet, where all the recieved reagent...
-
Copying data directly to a specific sheet [Closed]
Hi there! I am trying to create a spreadsheet in which I can enter information on one sheet and it automatically carries across that info to the c...
-
Conditional Formatting [Closed]
I am trying to set up formatting for five different colums as to when I click on the cell, it will give me a color based on the title. I have the cell...
-
A macro for creating multiple file from a source excel file [Closed]
My source file containing different codes in column 11 and I require a separate file to be created from this source file by filtering the column 11 by...
-
date format [Closed]
Hello, i have date format like 20131203 (year month day) i want to change it as 03.12.2013. please suggest Configuration: Windows 7 / Chrome 2...
-
it can not find the files [Closed]
Hi i installed your program to fix the corupted files the system can not find the files it dont show in the list how to do that???
Subscribe To Our Newsletter!
