Excel Forum
-
I wan't to make macro in Excel when i change value [Closed]
Hello, I wan't to make macro in excel that when i change the value of one cell on sheet1 macro changes the background color of the same value on she...
-
Create a loop in VBA [Closed]
I am trying to create a function however unable to progress as i'm stuck with the iteration part. Below are my codes. How do i go about creating the l...
-
Subtracting amounts from a fixed amount [Closed]
Hello, I need a equation for subtracting amounts that i entered from a fixed amount. Here is my screen shots. I enter 10000 in row 1 column A ...
-
Autopopulating new sheet based on an ans in 1 cell [Closed]
Hi, Hoping you can help. I need a solution whereby if I select a certain value from a drop down list it will autopopulate that row of data in a sep...
-
Option of selecting certain columns [Closed]
Hello, I want to select certain columns from one file and copying it to another destination file where selections can be done by giving command o...
-
How to automatically input a word into one cell [Closed]
Hello, I’m having a hard time trying to figure out how to automatically input a certain word into one cell if a different cell is less than anothe...
-
Copy and paste data upon click [Closed]
I have a set of data on A2 to A10. When I hit cell A2 which contain the word "January", the data will be copied into B2. If I hit cell A3 which co...
-
Resizing of Column & Rows in Macro [Closed]
Respected CCM team members, Greetings!! I am trying to insert images from a folder into excel by matching file names specified in a column, ever...
-
Highlight Help [Solved/Closed]
Hello, I am needing help with being able to highlight a cell based on another cell's value. Example: I am dealing with cells J2 and J3. I am needi...
-
Excel formula [Closed]
Hello, i need formula for below condition if b1 have any value consider that or consider g1
-
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
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Get More Followers on Instagram
- 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 Create a Gmail Account
- How to Disabled Write Protection on a USB