Excel Forum
-
want to high light to appear on both sheet [Closed]
Hello, I want to high light data on one sheet which appear on the other sheet. one updated sheet has 950 items and the older sheet other 350. I wa...
-
Conditional formatting from 1 sheet to another. please help! [Closed]
Dear users, I am supposed to track the progress of units. For example, there are 200 units and they are supposed to give us document A at a certain d...
-
A Tricky Macro [Closed]
Hello, I am new to macros and simply can not figure out how to write this one. ............... xs s m l xxl full Sku ........Qty 12345-111 0 ...
-
How to convert marks to percentage [Closed]
Hello How do you find a formula for calculating a problem like this one below; Cell A1 (Assignment 1Out of 20) Cell B1 (Assignment 2 out of 100) C...
-
Excel VBA/Macro [Closed]
Hello, Need help in creating a Macro to do the following I have a set of formulas on a worksheet called “Adam”. Cell A2 of worksheet “Adam”...
-
Changing font color in one cell when % in another cell changes [Solved/Closed]
Hello, I have a balance in B1 of what's owed on my credit card. I have the % of use on that card in D1, IE 35%. I want the font color to change ...
-
Text format to date/month/year on excel [Solved/Closed]
Hello, I have a huge list of data that has multiple dates/year along with different time format. I want to delete the time and obtain only the d...
-
Problm in Macro for deleting row [Closed]
Hello, Hello, First of all let me thank you all for sharing your knowledge in this forum. You guys are doing a great job. Now moving to my ...
-
I want to retrieve value from multiple sheets of same workbook [Solved/Closed]
Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...
-
excel formula using 3 tabs [Closed]
Hello, Can someone please advise if there is a formula or a macro that I can use for an excel spreadsheet. The first sheet tab consist of the ...
-
VBA FontColor Changing Adjacent Cells [Closed]
Good morning all, I'm stuck on a particular vba script for a Risk Register if anyone would be able to offer any assistance. Essentially the scri...
-
Stuck with Active sheet selection in Macro [Closed]
Hello, I am at very infant stage of working with Macro. I tried to run a macro where in the macro file creates a new file with data from original ...
-
Copy range data in a column to new column. [Solved/Closed]
Need help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula where...
-
Counting between dates [Closed]
Hello, I want to count the response to applications made to different organisations between set dates. In column C i use a simple 1 or 0 to indic...
-
Find number in cell and return text in adjacent cell. [Closed]
Hello, I'm trying to search a cell for a number, and if the cell contains a number I need to return a word in the next cell (the cell I am doing t...
-
What does this macro code mean? [Closed]
Hey, The below macro was posted by another user, aquarelle, and is very useful for inserting copies of rows in an excel sheet. I tried asking them ...
-
How to copy Data from one excel sheet to another by criteria vba [Closed]
I have data in Sheet1 and am trying to copy Range("A1:B8") from sheet1 to Sheet2 But while copying there are some condition Conditions are as foll...
-
Compare Fields [Closed]
Hello, My name is Swapnil Veer. I have two sheets in excel. I have to compare two different columns in sheets and add respective entry in front of...
-
VBA group by code [Closed]
Hi Everyone, I have data which looks like MANUFACTURER BRAND SEGMENT VALUE COLGATE Colgate BASE 500 COLGATE C...
-
Compare two columns [Solved/Closed]
Hello, In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column...
-
Transfer an entire row from one sheet to another [Solved/Closed]
Good Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns with...
-
Auto fill a Macro [Closed]
Hello, I want to auto fill a macro button down column A, that copies the information from several cells to a different sheet in the work book. here ...
-
Funct for adding +1 to a cell if there's a value in other cells [Closed]
Hope someone can help me with this, idk if it's possible in excel 2007. So basically I have a series of cells where 1 needs to be added depending ...
-
Conditional formatting, graded color scale [Closed]
Hello, I use graded color scale from green to red to color cells based on value Example: Value (color) 1 (green) 10 (yellow) 20 (red) If m...
-
Barcode scan [Closed]
Hello everyone, I would really appreciate if someone could help me out.. I'm a small reseller but now I have over 600 items. I use the same barc...
-
Add to Excel Macros [Solved/Closed]
Hello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, d...
-
Formula for Fetch Data from another sheet [Closed]
Hello, First I would like to asked that how could I insert a excel file or create a link, to understand my query. because the query that I want t...
-
Formula to copy data based on the text in the cell [Closed]
Hello, I need to find out how to do this (and would be grateful if anyone could help me with this): I have a tab (1) in Excel with ten thousand...
-
Locking/unlocking a range of cell depending on other cell [Closed]
Hi, I need some help - in cell A2 there can be entered a value from 1-48. If A2 is 1, then only cell B2 in column B should be unlocked (one cel...
-
A macro to insert pictures into Powerpoint slide from Excel [Closed]
Hi guys, I need your help with my problem. I have two files, one excel file that include a schedule for the whole year with 6 coloum (A Week, B ...
-
droplist of tab names [Closed]
Hello, I have a dropdown list of all my tabnames in a workbook. I want to create formulas that will read the selection in the drop down list and ...
-
formula to check days of the month and display only weekdays [Closed]
Hello, Pls help me I want a formula in excel that checks the days of a given month in turn and display only weekdays (skip weekends Friday and...
-
Multiple sheet, find, copy specific cell and paste [Closed]
Hello, i have a challenge for you. Im working on a doccument to pull information from a different sheet, that was imported from a web based huma...
-
Protected worksheet [Solved/Closed]
Hello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible plea...
-
Inserting image files from a directory specified by text string [Closed]
G’day CCM forum Quick hypothetical; I have a list of image file names in a column on an excel spreadsheet and a cell at the top of the page contain...
-
Copy row only if one cell's value is not 0 [Solved/Closed]
I would like to copy from a sheet to another only the rows in wich a cell ex.A1 has a value different from zero or blank. Thanks a lot!
-
Update value from table1 to table2 [Closed]
HI I have following two tables in excels. I want to copy values from table1 to 2nd one Criteria- we need to copy last five value. example shows in ...
-
F2+Enter key for Macro [Closed]
Hi I would like to request for a Macro that which execute a F2 and Enter keys. Please don't make a selection for a cells. I have a sheet where ...
-
Help with simple 2 step macro? [Closed]
Hello, I ask help to write a macro that 1. searches for 1 name "(Nghiem, Emily)" 2. and then types "X" in the next cell to the right. (What I tr...
-
multiple IF to show different statuses [Closed]
Hello, I am trying to have different status in my reports depending on the dates in different cells H START I ACTUAL START J DUE K DATE COMPLETED...
-
Copy Cells Relevant to Unquie Col Match and Save to Local Drive [Closed]
Hello, I am new to VBA, and was going back and forth between the available codes trying to create VBA to execute the following, but was not able to...
-
Conditional Formatting based on Text in another Sheet [Closed]
Hello! I'm currently using Google Sheets, but I believe the formatting is the same. I am working on two separate sheets, one "Cashflow" and one "In...
-
How to get a macro to work in all worksheets [Closed]
I know I am missing something simple here. I made a macro to create a chart from a template based on two ranges in a worksheet (Brisbane April Sales ...
-
double conditional formatting [Closed]
Hello, I would like to ask for your help with some conditional formatting, can’t really get my head around it. What I have: 1. Two columns in C an...
-
Put in today's date if other cell has color. [Closed]
Hi there everyone, I have a question about excel and I would love if someone could help me with it! I have an accountant sheet with invoices. When a...
-
A variation on the compare 2 columns in Excel [Solved/Closed]
Guys - Please advise and give me a few hints (or if you are generous write a macro for me [only joking ... a bit - please feel free to write it for me...
-
Automatic Data Transfer [Closed]
Hello, i am trying to extract data (certian colums )from one workbook to another workbook from a certian date, and everytime the orgininal workboo...
-
Call createJpg (reference sheet) [Closed]
Hey I have a doubt on this code ... > With OutMail > .SentOnBehalfOfName = "***@***" > .Display > ....
-
Search for a word in a worksheet and return row [Closed]
Hi, Hoping to get some help. I have a spreadsheet full of data in Sheet 1 from A1:AG159382. I would like to use a separate worksheet to search for...
-
If Then Formula [Closed]
Hello, I am trying to build an If Then formula. I am trying to reference a cell with a specific text in one cell like A2=Light and only if Lights is ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Install a VPN