Excel Forum
-
conditional formatting on multiple criteria [Solved/Closed]
hi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...
-
Conditional formatting cells containing IF rules [Closed]
Hello, Cell D11 contains the rule "=IF(D4>0,D4,"0")". I have set conditional formatting on the entire spreadsheet to show that if value is grea...
-
Copy data from another sheet if the condition is met [Closed]
Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...
-
Transfer Data IF.... [Closed]
Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...
-
Multiple formulas for multiple sheets [Closed]
Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...
-
Comparing columns in Excel 2010 [Solved/Closed]
Hello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...
-
Set Rows Height also Exception in Range [Solved/Closed]
Hello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...
-
Sheet List Window [Closed]
Hello, I would like to request that If user want to go to specific sheet it has to either press shortcut key or click arrows button in the left ...
-
Comparing Rows on two worksheets and pull data into a new sheet [Solved/Closed]
My requirement is following: I need to compare Column A, B and C of worksheet 1 to column A, B and C of Worksheet 2 If Above condition is met then I...
-
Find duplicates and highlight them across two worksheets [Closed]
Hello, my request is somewhat simple... I have two list of contacts, name, business name, address, phone number and email address. One was provide...
-
Listing ignoring blanks and avoiding duplicates [Closed]
I have a query but need to send a sample excel file for that. How do I attach a file as I do not see any link for that. Regards. jsexcel
-
IF formula [Closed]
Hello, I've got this formula that is supposed to give me two values however when ever I implement it, it seems to just give me one value all of time...
-
convert a number to a letter code [Closed]
Hello, This is to change a number to a code of letters to hide info in plain site. if my code table is 1 = C, 2 = D, 3 = E, etc thru 9 = K a...
-
Conditional formatting based on text in two different cells [Closed]
Hello, I have created a table with column A,B and C containing text for a risk register. I want to format column C in colours (red,amber or green...
-
Excel: Get Value from Sheet 1 to Sheet 2 [Closed]
Good evening, I need help please about what I am wrong. I have Cells A6 to F6 in Sheet1 has formula in it and I was trying to get the value of tho...
-
Macro to tell which sheet in master workbook is empty [Closed]
Hello, I will be grateful if someone can help me with below code. The code - Sub Demo() Application.ScreenUpdating = False Sheet1.[F2].C...
-
today function [Closed]
Hi, i am using today function in excel, i don't want change the date, when i open other day, it should show the previous date. Thanks Bbbp
-
Remove (Shape) Straight Line [Solved/Closed]
Hello I would like to request how to remove straight line shape through vba It was made through the following vba code Sub Str_line() ActiveSh...
-
Macro to tell user which sheet in master workbook is empty [Closed]
Hello, It would be helpful if someone can change a code to work as per my requirement. The code - Sub Demo() Application.ScreenUpdating...
-
Formula to count the duplication of a value in a range [Closed]
Hello, I am looking for a formula that can count the number of duplication of a particular value in a range of cells. Example: I need to know the ...
-
Macro to copy some cells in a column to another column [Closed]
Hello, I am trying to copy some cells from a column and post the value in another column. The column the values are posted to will vary depending...
-
Home Button [Solved/Closed]
Hello, I would like to request for the Macro which always take to "Sheet1" and also deactivated at "Sheet1" Thanks & Regards Configuration: ...
-
Next and Previous Button and De-Activate at Last Sheet [Solved/Closed]
Hello, I would like to request to create a button on Sheet that will click which goes to next sheet and this button also de-activate when it g...
-
Insert Custom footer - seems like a simple macro but won't work [Closed]
Hello, Simply trying to get any new workbook/sheet to insert path and file in the footer of the page with short cut key ctrl+shift+E. Below is th...
-
=IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work [Closed]
Hello, =IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work? Configuration: Windows 7 / Firefox 42.0
-
Positioning teams for tournament [Closed]
Hello, I'm creating a spreadsheet for a netball tournament and want it to calculate the finishing positions (1st, 2nd etc) based on the points sco...
-
macro to rename sheets based off cell value [Closed]
Hello, I have a workbook that I copy each month with dated sheets I would like to be able to rename each sheet based on the date.
-
Apply one macro to multiple rows [Closed]
Hello, So I have a question ragarding VBA. I have a sheet in which there is a column of dates and a column of values. When I input a date it retur...
-
Students Package Payment control [Closed]
Hello, I have the following columns then on SHEET 2(Students Sign Up control) I have a Sign up sheet I enter the student information like na...
-
Copy paste in excel sheet with macro based on matching column [Closed]
Hi, i have two sheets. sheet1 and sheet2, i want copy data from sheet1 in to sheet2 based on one matching column.i have one column called index w...
-
numerical into text [Closed]
I have 2.35 figure but i need to see two dollars and 35 cents in english
-
Need a formula to count the duplication of a value in a range [Closed]
Hello, I need a formula that can count the number of duplication of a particular value in a range of cells. Example: I need to know the count of ...
-
Spreadsheet [Closed]
Hi everyone, I have a question regarding this problem. I want when I enter in one cell code example: C.1.1.2., C.1.1.3, C.1.1.4. ..., that my other...
-
copying data one excel sheet to another with transposing columns [Closed]
We have a spreadsheet with rows and rows of data. Let's say column 1 is name, column 2 is address, column 3 is phone number, column 4 is rep name. L...
-
Select Cells from Column A which are hyperlinked to Sheets [Closed]
Hello, I would like to do the following: 1.Select Cells from Column A in "Index" Sheet which are already hyperlinked to Tab Sheets in the curre...
-
A macro to create new spreadsheet and copy data [Solved/Closed]
Hello, I m a University student and currently learning VBA programming. I have a VBA coursework where i have a file with 63 sheets. is any macro w...
-
Showing the $ value difference [Solved/Closed]
Hello, I am using Excel 2016.. and need some help. I am doing a budgeting sheet and cant figure out how to do the following; Column A - Budget $ ...
-
Formula does not stay the same! [Closed]
Hello, I am using Excel to keep records of different Projects. I have One general Worksheet and a good 20 Worksheets that follow for each individu...
-
Subtotal [Closed]
Hello, Im using subtotal and it isn't changing when i hide values. =SUBTOTAL(109,A42:GA42) Configuration: Windows 7 / Chrome 46.0.2490.86
-
Tell excel where to look [Solved/Closed]
Hello, I am trying to make a cell return a word when you tell it which cell to look in for that word. If i type J2 in a box i want a cell to then l...
-
Copying rows when inserting a column [Closed]
Hello, everyone I have a problem with my database I am inserting new columns when there is a new company added and the go between two existing columns...
-
Copying Conditional Formatting to Several Cells Then Editing [Closed]
I'll start off by saying I am a novice (at best) when it comes to using Excel. WHile I have figured out some things I am sure I am probably not doing ...
-
Excel: If Date =, then enter a value [Solved/Closed]
I am using this formula and it works well: =IF(A8=DATE(2015,3,27),"1","--") How do I now create a string to check a number of dates (company holid...
-
Auto Copy based on Condition [Closed]
Hello, I have developed an Auditing sheet in Excel in which the results are copied into a Word document to create an audit summary report. How d...
-
Adding two non-adjacent cells (number and text) [Solved/Closed]
Hello, I seem to be having a problem with a nested IF(statement) I am on a separate worksheet that I use to calculate my formulas for my summary page....
-
Connecting Excel database to the company's website [Closed]
Hello everyone and thank you for any help on this problem that I have. My boss just asked me to connect the excel database I am finishing up on cre...
-
Drawback of Copy and Clear code [Solved/Closed]
Hello, I have requested that please solve this issued if it could be solved. I have found major drawback (May be I am wrong) in the code of Copy ...
-
Macro to create list from master sheet [Closed]
Hi! I need to create a macro that will generate individual lists for employees based off a master sheet. on my master sheet (that is what the sheet...
-
changing a frequency into a list [Closed]
Hello, I have a list of names and numbers and I would like the list in full i.e. jane 4 chris 2 result jane jane jane jane chris chri...
-
Dynamic Hyperlinks [Closed]
Hello, I'm currently working on a spreadsheet which has links to external files for example A1 - link 1 - file1.pdf A2 - link 2 - file2.pdf A3 - li...
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- Facebook Code Not Received
- How to Install a VPN