Excel Forum
-
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 ...
-
Running a report while pulling data from multiple workbooks [Closed]
I have never used excel macros before and I have been tasked with creating an report that runs automatically monthly, and it has to pull multiple piec...
-
How to search Particular number string [Closed]
Hi, I want to search particular number string from all the number data. E.g. - 9822013351 9822012146 9822030078 9822046440 9850038947 ...
-
changing text and colour of a cell linked to another cell [Closed]
Hello, I understand how to reference a cell to have the same text as another cell in a different worksheet, but how do you also get excel to change...
-
conditional formatting - changing values [Closed]
Hello, I am looking for a conditional formatting or/and formula to apply the following: -in a selected area (column, row, worksheet) values sho...
-
A macro that can determine a file and extract data from it [Closed]
Hello, I'm using Bluebeam Revu and exporting markups into a CSV file for different projects. I'm looking for a macro that can extract data from th...
-
calculating fuel surcharge [Closed]
Hello, I have the amount which includes freight charge+fuel surcharge that is $14.36. It is said that fuel surcharge is 22%. what formula should w...
-
assistance with date formula [Closed]
Hello, I got a whole lot of data saved as dd/mm/yyyy - need them to be converted to read yyyy/mm/dd - any ideas?
-
IF formula for a range almost works, except with blank cells [Solved/Closed]
Apologies if the title is too vague. I will if necessary rewrite it to comply with forum rules. I have posted this same question here: https://www....
-
Set Next visible cell to a formula [Closed]
Hello, I'm using this code to set specific text to visible cells in Column AA. How can I change the below or use a similair method to set the cor...
-
Formula required numeric convert in words [Closed]
Hello, please confrim how to convert numeric in words in excel. Simple formula required
-
Sending Auto-Emails from Excel When a Cell Changes [Closed]
Hello, I am putting together a spreadsheet to track work orders and I would like to know if it is possible to have the spreadsheet send an automat...
-
positions (1st, 2nd, 3rd etc) [Closed]
No Name Eng Maths Bio Econs Distinction Credit Pass Fail 1. John Dan 56 67 78 66 ...
-
Excel macro to create dropdown value of the sheet and values [Closed]
Hello, I have spreadsheet containing multiple sheets and values in it. I would like to make a macro tool to create a dropdown button of the sheet a...
-
Excel - possible to populate fields using a hyperlink? [Closed]
I'm creating a job tracking workbook, with a master sheet on page 1. Additional worksheets are used to list activity on the job. From sheet 1, I am cr...
-
Auto Transferring Data from one cell/row to another sheet [Closed]
Hello, Good Morning. I have a list of transaction in one sheet. With a column showing the sheet name where the data of that row should be trans...
-
EXCEL 2013 Compare Column A to Columns B,C,D [Closed]
Hello, I am trying to Compare Column A to Columns B,C,D and put location of match in column E. Is this possible? Configuration: Windows 7 ...
-
Change cell colour based on values in other columns. [Closed]
Hello, I would like to change cells in column C base on numbers in Column A and B. So for example, A1=3, B1= 1, C1= Red A2=2, B2= 2, C2= yellow ...
-
copying columns of data on multiple sheets in another worksheet [Closed]
Hello, I have a master budget with a summary on one worksheet, and department budgets on subsequent sheets. When there is a number on the summary sh...
-
Need a Macro to Copy a Sheet and Populate from a List [Closed]
Hey there! I'm new to using macros on Excel, and I've been having some trouble. I have a sheet called "Rating Plate Template" which has been sized ...
-
How to automatically update data from one sheet to another [Closed]
Hello All, New user here. I have tried to research an answer to my question to no avail. I have found similar situations and solutions, but not o...
-
Macro: compare 2 wkbk, paste un-duplicate code in the 3rd wkbk. [Closed]
Compare 2 workbook and paste the non-duplicate data in the third workbook in an empty cell.
-
Index , array and need help with print [Closed]
Hello, I have a database and I created a form using this database . I used "index" syntax and it works but my problem is I need to print this form...
-
Automatic data transfer [Closed]
Looking for a excell expert Is this possible? I want to transfer multiple cells Of a worksheet to another sheet in the same work book with a single ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB