Excel Forum
-
Copy Potential data from one sheet to another if condition met [Closed]
Hello all, thanks for taking the time to read this, I have a very specific formula request, or at least a request for direction on how to...
-
need to match two values and return another value [Closed]
I have two spreadsheets in which I need to match two values and return another value. So, in my case, if Column C and Row 24 match (in spreadsheet...
-
VBA - Filling blanks across multiple Worksheets [Closed]
Hi, I currently have an excel file containing multiple worksheets. Rather than filling in blanks using the same value above is it possible to...
-
Create Excel Macro for Automailer [Closed]
hi i Have one excel book,in excel sheet 1 contains distributor name & their E mail address,and sheet 2 contains some large amount of data of...
-
drop down list formula [Closed]
Hi, I am fighting to find the right solution for the following: I have in Column A a drop down list with two variables. -When they choose...
-
VBA - Filling in blanks across multple worksheets [Closed]
Hi, I currently have an excel file containing multiple worksheets. Rather than filling in blanks using the same value above is it possible to...
-
Compare data and summarize on seperate sheet [Closed]
Hello, Each month I download a 1,000+ line of Part Numbers with inventory qty and value to an excel tab. I want to compare the part numbers...
-
Need to create a macro [Closed]
Hello, I am looking to create a macro that will take only newly entered data from column A and column B on two worksheets (Pipeline - PM and...
-
Search/Transfer Patient Data [Closed]
Hello, If anyone could help me, it would be greatly appreciated. Ok I have a spreadsheet with different patient names. If they are inpatient...
-
Excel - Macro to copy data from one workbook to another [Closed]
I need to copy data from one workbook and append the content to another workbook (WB). Ex: WB1 (source) has data in column A B C D E WB2...
-
Macros [Closed]
Hi, I'm new to macros and have only a little experience in programming. My question is, how can I get Excel to take inputs from two separate...
-
if then formula question [Closed]
Hello, If you have a value in cell a that equal 42:15 (42 hrs and 15 min) and in another cell you want it to look at that cell, determine if the...
-
pop up reminder vba [Closed]
hello everyone, i have very little knowledge about excel vba, actually i am making an excel file. i want it have...
-
Excel templates to PDF [Closed]
Hello, I am delighted to use the forum for the first time. I encounter an issue with my excel vba function. Not being a coder, I went...
-
validation code [Closed]
Hello, Why can't I get a validation code? Configuration: iPhone / Safari 4.0
-
format a group of cell by referring to a series of number [Closed]
Dear Sir, How to format a group of cell by referring to a series of number with different color. The color will change accordingly when the...
-
cut and paste a range of cells if two cells are duplicates [Closed]
I have a spreadsheet of documents that are in revision along with their status and other criteria that change daily. Row B contains the...
-
Conditional formatting using dates [Closed]
Hi, Can anyone help please? I have: a column (E) of cells each containing options from a dropdown list named...
-
Another copy from Master to specific sheets [Closed]
Hello everyone, First post here and I am not, by any means, an excel expert (my husband thinks he is, which is why I'm here, lol). So here is...
-
Macro for looping charting data keyed from two columns [Closed]
Hello and thank you anyone for reading this. I have a quandary that is beyond my VB skills and am looking for any help possible. I need to...
-
Question about Macros [Closed]
Hi, I'm looking for help regarding macros/ adjusting a macro. My issue: I'm trying to copy and paste macros from 100s of files to 1...
-
macro to create new workbook and copy data [Solved/Closed]
Hello I am looking for macro to copy rows based on partial cell content of a column. I have an excel spreadsheet called "arc.xlsx" from which I...
-
Macro to move data between sheets on condition [Closed]
Hello, I am a beginner to using Macros in excel. I understand there are lots of things on here, and the internet in general, telling you how to...
-
Need cells to populate with text when I add text to a 3rd cell [Closed]
Hi.. Don't know if this is possible, I have searched online in various excell sites including excel sites from office. What I want to do...
-
Using 1 Macro on Multiple Files [Closed]
Hi, I'm trying to copy and paste macros from 100s of files to 1 master file in excel. I'm using macros to do this however I have to open or...
-
Issue: Linked Worksheets won't autopulate format [Closed]
I'm trying to create an excel workbook that keeps track of each of my files which are labeled by the client's last name and file number. Each file...
-
How to copy the format from one cell to another [Closed]
Hello, I have a table SalesPeople (Code and Name). Every code is unique. I have added a colour on each code and name (each row). Then I...
-
Excel Date Formula (IF) [Closed]
Hello, I'm in need of some assistance with an excel date formula. I'm need to look at 2 cells in the same row which contain dates or may be...
-
Copying Data [Closed]
Hello, I presently have stock sheets with details of suppliers, items, quantities held-in stock and on display, price, etc. Whenever I reduce...
-
Verify dates in 2 cells < specific date - write Yes or No [Closed]
I'm looking for a formula which will look at 2 cells in the same row which contain dates or may be NULL and determine if either of them are...
-
Accounts receivable aging formula [Closed]
I need help with accounts receivable aging formula. A1 IS TODAY'S DATE G4 IS BILLING DUE DATE H4 IS PAYMENT RECEIVED I4 IS DATE RECEIVED...
-
Macro for copy the data from several excels to one excel [Closed]
Hello, Hi, I need help for write a macro for copying the text data from several excels and paste the same data in the form of columns in other...
-
short cut between 2 sheet [Closed]
can someone show me a short cut how to transfer a date or number from sheet 1 to sheet 2.
-
Chart out a grid using excel [Closed]
How can I build a grid using an existing excel sheet that already has the cell references and the name. This document has four groups each...
-
Conditional formating [Closed]
i have a row of initials: MM MM MM MM LL LL LL BB XX XX MM CC CC CC, each pair is a column these correspond to booking dates, so if the initial...
-
to get notification in outlook from excel [Closed]
hi iam using excel for my work and i am trying to manage due dates ie if a due date is arrived it shoud be be notified in outlook as notification...
-
Copy potential data from one sheet to another if condition met [Closed]
Hello, I have a very specific formula request, or at least a request for direction on how to write/learn to write it. I have two sheets of...
-
Conditional formatting between 2 different columns [Closed]
Hello, If someone can please help me. I have 2 columns. One column needs to be formatted w/ a specific color within a range of numbers...
-
Command Button to Move Data from One Sheet to Another [Closed]
Hello, I have a report with data from column A:AD. I also have a status column. I want to remove data with a specific status from the one...
-
Compare values in two columns and return the value from third [Solved/Closed]
Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I...
-
Monthly to Daily Schedule Automation Help [Closed]
Hello, I am posting this again as I believe there were some issues with my original post. Thanksin advance!* I am looking for some...
-
Conditional Formatting [Closed]
Hello, I have 2 columns. One column needs to be formatted w/ a specific color within a range of numbers depending on the number in the other...
-
Need help configuring for patient data [Closed]
Hello, Ok I have a spreadsheet with different patient names. If they are inpatient then there is a column that is blank. Once they are...
-
Place specfic text in cell based on text in an adjacent cell [Solved/Closed]
Hello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that...
-
Change format of a cell when another cell is not null [Closed]
How do I highlight a cell or row when another cell contains anything? Thanks!
-
every day the date changes [Closed]
say for example A1 is 9/4/2016 the next day when ever i open that sheet then the new date appear in A2 as 9/5/2016 the same continues on till...
-
My spellnumber to Thai Baht. [Closed]
Hello, I Can change the Number into Spell but the problem is it does not convert in Thai Baht. Present Situation =SpellNumber(58.20) = Fifty...
-
Entering Data in a column for prescribed number of times. [Closed]
Hello, How to enter a specific word from from one excel sheet into a column in another excel sheet for a number of times mentioned in the...
-
Conditional formating [Closed]
Hello, I'm trying to make multiple cells turn red if a single cell has a certain value. So for example is B3 says "abc" cells B3:F21 should...
-
VB code for manual entry in range of cells [Closed]
Hello, In my work sheets the values in some of the cells in range are determined through formula. When someone wants to change the value...
