Excel Forum
-
Average Labor Burn Help! Closed
Hello, I am trying to do a sort of a burn. I need the cell value to be copied linearly across an x amount of rows, and the number or rows that it ne...
-
Conditional formatting on a sheet to grey out "Closed" Actions Closed
Hello, I'm trying to turn the rows in a spreadsheet grey when an action is closed and i've looked at previous responses but when I try them on my ...
-
Macro needed to copy entire row from sheet1 to sheet2 Closed
Hi, Could someone please help me with my Excel problem. The problem is How to copy few columns of a row(s) from one sheet to another that contains ...
-
Keep Drop Down/ Data Validation with Macro Closed
Hello, I searched around a lot and could not find an answer to this: I need to replace values in a cell with a macro while keeping the "Data Valida...
-
formula to copy cells that meet condition Closed
Hello, I have 5 sheets of data and columns D-G on those sheets are formatted with a drop down menu and color fill based on the selection. I would...
-
If Then Formula Closed
Hello, I need to count radios. When someone checks out a radio I want Excel to add up how many radios are out and how many are left. I added data va...
-
Repeating rows contents for a set number of user defined rows Closed
Column A Column B Product number Number of Sizes 1234 4 I would like to see the product number r...
-
Macro to insert rows with formula Closed
Hello, I need help. :( I would like to create a macro to automatically insert lines at the bottom of all my filled in row. After the lines are i...
-
Command Button to Move Data from One Sheet to Another Closed
Hello, I have a report with a data sheet and a data removed sheet. The data sheet is from column A:AC. In column Q I have different statuses tha...
-
Macro to copy list of values to another sheet , 13 times each Closed
Hello community, I need to copy list oif 1400 values from one sheet to another. Each value has to be copied 13 times. Can anyone advise on macro? ...
-
Macro to copy list of values from one sheet to another Closed
Hello, I need to copy list oif 1400 values from one sheet to another. Each value has to be copied 13 times. Can anyone advise on macro?
-
Excel Formula Closed
I need to match two cell in two different sheet but it can be a like or similar. Like if Found something written on Cell B1 (Eg Hyderabad) in Secon...
-
Transfer info from sheet 1 to sheet 2 Closed
Hello, I have a multi page spread sheet. Sheet one is a log of names with columns for dates they attend meetings. Sheet two is a log of attendan...
-
Add selectable prefix to cell contents Closed
I have a list of numbers in rows: 1, 2, 3,...999 I need to create them as 1001, 1002, 1003...1999 OR 2001, 2002, 2003 etc Sample Code: Cells(1, 1...
-
formula to find out all the master ID's Closed
Hello, My first columns is a Master ID which is unique for every row. My 5th column is the item name where item name's do get repeated. I need a...
-
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 write/lea...
-
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 A) ...
-
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 ente...
-
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 resep...
-
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 the f...
-
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 enter...
-
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 to se...
-
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 Pipelin...
-
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 then ...
-
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 (targ...
-
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 cel...
-
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 hou...
-
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 pop...
-
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 online l...
-
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 number ...
-
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 individual do...
-
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 "MINOR" "MAJOR" "CRITICAL" ...
-
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 my qu...
-
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 find a ...
-
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 master f...
-
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 wou...
-
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 cre...
-
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 is... ...
-
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 download...
-
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 on ...
-
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 have an...
-
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 NULL...
-
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 the q...
-
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 greater th...
-
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 K4 ...
-
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 exce...
-
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 containing ...
-
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 next...
