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...
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...
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 ...
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...
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”...
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 ...
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...
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 ...
Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...
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 ...
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...
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 ...
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...
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...
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...
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 ...
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...
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...
Hi Everyone, I have data which looks like MANUFACTURER BRAND SEGMENT VALUE COLGATE Colgate BASE 500 COLGATE C...
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...
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...
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 ...
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 ...
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...
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...
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...
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...
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...
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...
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 ...
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 ...
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...
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...
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...
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...
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!
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 ...
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 ...
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...
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...
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...
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...
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 ...
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...
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...
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...
Hello, i am trying to extract data (certian colums )from one workbook to another workbook from a certian date, and everytime the orgininal workboo...
Hey I have a doubt on this code ... > With OutMail > .SentOnBehalfOfName = "***@***" > .Display > ....
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...
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 ...
DON'T MISS