Excel Forum
-
Macro to compare the 3 columns "SEC Code Closed
Hi All, I would really appreciate your help in providing me with a macro to save me some time on the following. 1- Everyday i receive 2 reports ...
-
How to save a copy of an excel sheet using macros? Closed
Hello, excel guru's, I am struggling with a problem which should be easy (i think), but with my lack of knowledge of VBA i am stuck. I have an...
-
Counting sites visits within a year Solved/Closed
Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits ...
-
Compare data in two columns Closed
Hello, Q 4 U - pls and thank you CCC=characters/letters NNN=numerics Trying to compare these two columns and identify partial matches betwe...
-
Color Fill and Conditional Formatting Closed
Hi, I'm running Excel 2013 on a Windows 7 Ultimate box, and I have a spreadsheet containing 14 columns and 253 rows. I've made one column, where I ...
-
VBA for comma delimited Closed
I have a column of numbers. I want to transpose the column to row but have all numbers in one cell separated by a comma. What is a good VBA to use. ...
-
Need different data each time from different sheet Closed
So I'm making an invoice form in which i need to insert data from another excel, which is a list that includes names/e-mails/amount paid/etc. Is the...
-
Need a search function Closed
i have BPS in cell A1 and the pay Cell A2 on sheet 1 and on sheet two i have a data in this range g3:aj23 now my question is for example my A1 ce...
-
checklist thesis Closed
hello we type the number of votes in a certain activity but i would like to know how to use excel to compute the percentage of the population that ...
-
How to apply conditional formatting Solved/Closed
I would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and unhighligh...
-
Copy cell data to next row for multiple cells Closed
Hello, Need help copying cell data to next row for multiple cells. e.g. Source data - A1 Cat A2 (blank cell) A3 Dog A4 (blank cell) A5 Hen...
-
Conditional Formatting (Highlighting) Closed
Hi, I would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and un...
-
Copy multiple rows and transpose to one row Closed
Hi! I am trying to copy multiple rows of a spreadsheet and transpose them into one column of another spreadsheet. I know how to do this one row at ...
-
Copying rows to another sheet Closed
I'm looking to copy certain cells in a row to a new sheet if another cell meets certain criteria. If column O has "Yes" i need to copy cells A-F o...
-
How to copy data to a different worksheet? Solved/Closed
Hello, I would like to copy data from a specific cell of a worksheet and paste into a specific cell in a different worksheet Eg from cell b2 of a l...
-
How to send automatic email from sharedrive Closed
Hello, I have to send a tracker automaically to my lead at eod everyday from sharedrive. Can anyone pls help me in this??
-
Conditional Formatting - Dates Solved/Closed
Hello, On a spreadsheet, the cells in column N contain a date. I need any date that is 6 weeks ago or longer to be highlighted. How do I do ...
-
Rearrange multiple columns in four columns, VBA Solved/Closed
Hello guys, An excel rookie needs the help of more experienced users of Excel and VBA. I have a data set that looks the following way: There ...
-
Copy data to multiple Excel sheets after creating Closed
Hello, I have a standard template excel file - excel.xls. I have a list of servers in a text file - names.txt. I want to create multiple files of ...
-
Sorting 2 columns of names with the same 2 columns& limited rows Closed
Hello, I am looking for some help with an Excel Spreadsheet. I have an Excel Spreadsheet with room for only 2 columns and 5 rows. I am tryi...
-
Trying to autopopulate multiple spreadsheets Closed
I have a workbook with contact and personal information of an organisation. I would like to have this information auto populate to separate sheets in ...
-
Matchpoint score Solved/Closed
hello I hope that someone can help me. I have an excel sheet in which I record scores of teams and I would like a formula to calculate the points acc...
-
Copy data into new rows (row 2, 3, 4, et cetera) Closed
To Whom It May Concern: I'm trying to get data that's already made into a different part of the same sheet. I want to make sure it's recorded in o...
-
How to change text formating in a cell? Closed
Hallo!! I am working on a dictionary and I want to change the formating of the text of column B by setting prerequisites. Example: "Απαλλοτρίωσ...
-
Formula to return cell value in Excel Closed
Hello, System Configuration: Windows / Chrome 51.0.2704.106 I am trying to configure a formula that returns the value of a cell if is not b...
-
Populate Data Closed
I need to auto-populate data from a master worksheet into multiple worksheets, while having the ability to add/delete rows in the master worksheet. Th...
-
How to match contents in 2 separate cells? Closed
I have data in 2 separate cells. I need a formula that will pick out the first 3 characters from each cell and show if a match (true/false). Any hel...
-
Copying data from an Excel 2010 table to a String or Word File Closed
Can anyone help me please with the following problem: Search in Col A of an Excel Worksheet table for expression 'Employee' (exact cell location in Co...
-
Sorting 2 columns of names with the same 2 columns& limited rows Closed
I have an Excel sheet with room for only 2 columns and 5 rows. I need to sort 8 names alphabetically in those 2 columns and 5 rows. For instance...
-
Automatic increment number for invoice Closed
Hello, i do make invoice sheetwise due to the same sheet we add expenses to calculate profit, now how do i get new number whenever i copy the sh...
-
Compare values in two columns and return the value from third Closed
Hello, I have a table containing three columns. Column A shows the status of a product, "To Review", "Under Review", "Review Completed" Column...
-
Transfer data from the master sheet to other sheets. Closed
Hello, i am maintaining a master excel sheet of out tele callers in which they all enter their calling data. i want to get the data in different d...
-
Removing Extra columns after the end of the month, Closed
Hello, Be Happy, i want to ask you that my company's month starts from 23rd and ends on 22nd, so how the extra columns can be removed automatically...
-
Auto E-mail when cell displays "Yes" Closed
Good Day Could someone please assist me with my query? I do not have many experience with VBA Macro, and would appreciate a simple answer. I ha...
-
How to use conditional format based on text? Solved/Closed
Hello, I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "Fi...
-
Cut from one workbook to another workbook Closed
Hello, from data specific cell value match then entire row cut and paste another workbook sheet in excel vba formual System Configuration: ...
-
Copy and convert data Solved/Closed
Hi, in advance I would like to thank everyone for reading my post and providing any assistance. I have an exported worksheet with 50 rows of data (30...
-
Input part numbers and description into selected spreadsheet Closed
Hello, I am compiling a excel work sheet, so far I have created 'buttons' that take me to the correct spreadsheet sections I have created. What I need...
-
Creating a time frame Closed
Dear excel gurus/geniuses, I'm new to excel (as in, new in discovering what a powerful software it is!!) I want to calculate approximate time (day?...
-
Wanted formula Closed
Hello, Want to know the formula Eg:- if a sale of one month is 585 than how to remove 30% of that amount... Wat formula to use in excel sheet
-
How to loop sheets through in a worksheet Closed
For each tempsheet & i Loop them and perform a same code
-
Create a spreadsheet that captures data in sheet 1 Closed
Hi All, Hoping someone can help with a query. I want to create a spreadsheet that captures data in sheet 1 (name, company, notes etc) and populates...
-
VBA Excel [All versions] - Calendar Control Closed
RE: https://ccm.net/faq/36865-vba-excel-all-versions-calendar-control The article "VBA Excel [All versions] - Calendar Control" looks very promisi...
-
VLOOKUP, IF? Question assigning value to text options Solved/Closed
Hello, I need to make an spreadsheet that corresponds different text values and gives them a score. I have several tables set up, that I was tryin...
-
Data showing who pays a doesnt after manually input receipts Solved/Closed
Hello, Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the ...
-
Sorting a massive amount of data Closed
Hello, My boss has asked me to find out how much each sales person has sold in their first 8 weeks, 16 weeks, 24 weeks,40 weeks, 1 year, 2 years a...
-
Finding a cell and adding 1 to a cell in an adjacent column Closed
I am working on a simple stat program to replace a tally sheet we use in basketball practice. I have created a page to choose names and statistics to...
-
Difficulty to open Excel files Closed
Good day! The problem is the following! When opening any Excel files (no matter what size and no matter of the mesh open or locally with a computer) t...
-
Compare sheets and put missing rows into third sheet. Closed
Hi to all the CCM members. I have a problem that I need assistance with and I would greatly appreciate it if a VB guru could help me with a script ...
-
Copying rows into new sheet Closed
Hello beautiful people of CCM, This is my first time posting and I am so excited to be part of such a wonderful community of intelligent minds. I t...
