Excel Forum
-
Creating a Macro [Closed]
Hello, I am trying to create a macro that takes information from 6 separate sheets and pools them into one excel document. Essentially it would ta...
-
Excel Challenging - Please Help [Closed]
Good Day Everyone. I'm stuck on the below situation and your help will be much appreciated. Let's call as: Worksheet] 1: WorkSheet]...
-
Conditional Formatting Based on another cell [Closed]
Hello, I'm trying to make a budget spreadsheet and want to format the cells if there is an omission. If a value has been entered into cell C3 ...
-
Comparing two sheets [Closed]
Hello guys, trying to do a spreadsheet at work for a stock take but a little bit more automated. The basic sheet is there but the csv that comes fr...
-
NEED AUTOMATICALLY CHANGED AMOUNT PERCENTAGE. [Closed]
Hello, I need to help to ms excel sheet PERCENTAGE% 0.25 ENTER AMOUNT PERCENTAGE% 25,000.00 AUMATICALLY CHANGE 300000 AUMATI...
-
Need macros solution, thanks in advance. [Closed]
A B C D 887806009723 B00A3ZFW7I 887806009723 887806009730 B00A3ZFWUU 88780600973...
-
count if rows contains specific year [Closed]
Hello, I need to count how many rows contains a date with a specific year, but with the following doesn't work: =COUNT.IF(D3:D3394;"*2014") I cha...
-
Insert a row after "," in a cell [Closed]
Hello, I have a 2 columns such as below: Name Rules John T3456,T4567,T6799 Cersei T5643,T4532 I would like to have a macro that...
-
Checkbox [Closed]
I'm trying to use an Excel worksheet to take attendance. I've been able to find a solution using Apple's Numbers, but not so with Excel. Any ideas?
-
how to convert number to word in excel using formula [Closed]
Hello, HOW TO CONVERT NUMBER TO WORD IN EXCEL USING FORMULA Configuration: Windows 7 / Chrome 43.0.2357.130
-
Copying text to different sheets based on criteria [Closed]
Hello, I have a large speradsheet that records activity. I want to copy a row of items from one sheet to another if the status is 'done'. The if...
-
Excel macro copy cell based on date. [Closed]
Hello, I got this kind of problem. Sheet1 for example cell A1 contains salesmen margin of a month and B1 contains drop list of months and Sheet2 has...
-
Apply a number to differentiate cells with same value [Closed]
Hello, Can someone help me please? Here is my issue. So I have a long list of memberships. The issue I have is that I have one primary member that ...
-
Formula to sum information if it relates to certain text [Closed]
Hi I am trying to analyse some data. In one column I have the description of the data and in another column I have the cost. The descriptions are all ...
-
apply a number to differentiate cell with same value [Closed]
Hello, So I have a long list of memberships. The issue I have is that I have one primary member that has a spouse and 2 kids and each one needs a ...
-
A Macro to add data from sheet 2 to sheet 1 with repeating rows [Closed]
Hi, i want to create macro that would take repeat rows from sheet 2 to sheet 1 X number of times e.g Sheet 2 would contain following data Code Des...
-
Macro for transferring data and automatically puts it in order [Closed]
Hi all, There were so many topics to find macro's that i had to browse a lot but couldn't find what i was looking for on the moment so i thought i ...
-
how to convert date into words(english) in excel 2003 or 2007 [Closed]
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Two Tho...
-
Input data from an input form to a permanent file [Closed]
Hello awesome forum people! re: EXCEL worksheets Is there a way to be able to input data into a form on an EXCEL worksheet, containing Name, Addres...
-
Create Multiple Workbooks in a particular format from a Table [Closed]
Hi, I want to create a macro wherein I can create multiple workbooks in a particular format from the data from a master table in a excel workbook. ...
-
Error trying to populate new worksheet using macro [Solved/Closed]
Hey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...
-
add string only if a text is present in a cell [Solved/Closed]
Hello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...
-
FORMULA FORMATION HELP [Closed]
Hi, I am just starting to understand Excel. I have a database that is used to enter our employee's time slip information, therefore, there is about a ...
-
combining 5 workbooks into one and removing duplicates [Closed]
Hello, I have 5 address books saved onto separate spreadsheets and I would like to put them all together to make a master Address book. I would nee...
-
Copy cell from another sheet where cell is value...? [Solved/Closed]
Hi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...
-
macro for filling data from specific cell to another [Solved/Closed]
Hi all, i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column. screen shot i...
-
Complicated if/then copy operation? [Closed]
if (column range; eg, A8:A42) has any value, then Copy a cell (formula; in C2) two columns to the right of every cell in that column (A) that has a va...
-
Rows And Columns [Closed]
Hello, I have the ffg problem, i have a table as below: PN H1 H2 H3 H4 A AB AC AD AE B AB AD C AC AE D AB AC AE and I want it t...
-
Color cells if a corresponding cell is colored [Closed]
Hello, I have columns a and z. If I color column z, say Z45, then A45 in column A should automatically be filled of the same color in z45. Not...
-
Nesting IF formula problem [Closed]
Hello, I'm trying to set up a worksheet for student participation grades. Once I arrive at a participation average, I'd like to have a formula to...
-
Error: embedded Excel spreadsheet [Solved/Closed]
Occasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...
-
Excel -formula that excludes names if other colums have info [Closed]
Hello, I have a list of 50 names in Column F, I used the Coutif formula to tally the total names in colum Q:5. ex. =COUNTIFS(F3:F1436,"=bill*"...
-
Seeking macro for data copying [Closed]
Hi everyone! I could use your knowledge, please! I'm creating a job tracking workbook, with a master sheet on Sheet1. Sheet2 is the blank worksheet...
-
Excel Formulae - returning a zero value [Closed]
Hello, I'm trying to set up an excel quotation sheet using the following formulae =SUM(B6*C6)+(D6*$E$3/1000) Cell E6 = the quantity Cell B6...
-
Macro that when name is entered creates copies of other sheets [Closed]
Hello, I really appreciate anyone who can help. I have a Skills assessment Workbook where Managers are writing on Sheet 1 the names of their employ...
-
Add entries from a template to a masterlist [Closed]
Hello, I have a excel template scorecard which I would like the answers from certain cells to record entries from the scorecard to a separate exce...
-
Master sheet to work sheets [Closed]
I have an education master template and many other exact duplicate worksheets in a workbook. Each of the other worksheets is differentiated only by th...
-
How to Populate Multiple worksheets [Closed]
I recently became the Treasurer of a VFW Post and am trying to find an inexpensive way to keep books that have been done by stubby pencil for years. ...
-
format cell [Closed]
Hello, Can someone please help. Is there a formula to highlight a cell in a row in column P if it is not equal to the same row in column C. I wo...
-
Splitting spreadsheet by account number [Closed]
Hello, I have a spreadsheet with around 500 accounts in. Each account contains a large number of rows of data. I would like to write a Macro so as...
-
Splitting data by account number [Closed]
Hello, I have a spreadsheet with around 500 accounts in. Each account contains a large number of rows of data. I would like to write a Macro so as...
-
Conditional Formatting [Closed]
Hello, I have created an excel database with all of the football games I have been too. In one column I have the home score and the next the away sc...
-
in one cell more value and another cell less value i need to com [Closed]
Hello, in one cell more value and another cell less value i need to come automatically higher value in that particular cell if there is formula li...
-
rupees into words [Closed]
Hello, PLEASE CONVERT MY INDIAN RUPEESINTO WORDS RS 10423859/-
-
Vba code to create new folders and subfolders [Closed]
Hello, Pls could anyone show me a code that will allow me to save an excel file as follows: Year/month/week/myexcel.xsl Year- I will like it t...
-
Need value as per given criteria [Solved/Closed]
Hello, There is a range given on one column and on the other column there are points. Ex: 200 - 180. 10 points 179 - 160. 9.5 points 159...
-
Removing duplicate by comparing with another column [Closed]
Hello, I am working on an excelsheet where I need to remove the duplicates. Example: Column A Column B Doc A ...
-
count appearance of multiple letters in a cell [Closed]
I'm trying to figure out a way I can count the amount of appearances of certain letters within a cell, and/or just mark true/false if any of the lette...
-
If then formula with date [Closed]
I have a spreadsheet that is tracking when a task is completed in Column C and then generating the next due by date in the next row column A so you kn...
-
copy info macro [Closed]
Hello, I need a macro that can copy specific information based on specific criteria, and to be pasted into new sheets. so for an example i need all ...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account