Excel Forum
-
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...
-
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 with...
-
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 data,...
-
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 depending o...
-
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 sheet ...
-
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 need...
-
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 assistance o...
-
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 colu...
-
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 discharged...
-
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 cell, I ...
-
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 the...
-
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 Dol...
-
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 first s...
-
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 turn r...
-
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 manually...
-
blinking cell [Closed]
Use hyperlink addressing in Excel cells, to go to an other cell within same workbook. Can anyone advise how to program VBA to make the targuet cel...
-
Copying unique data that ends with a specific character [Closed]
Hello, I want to create a workbook that has a main input worksheet, then automatically copy new data that ends with a specific character to a spec...
-
using "if" in correlation with "date" [Closed]
Hello i'm trying to fill up specific cell on one sheet on a certain date and the content to go on another specific cell on other sheet. EG: on 3rd...
-
How to disable edit option once data inserted [Closed]
Hello, I need help can any one help me on the below query once data entered in excel it shouldn't edit by anyone Configuration: Windows ...
-
need to summarise data [Closed]
Dear All, Link to my document. https://drive.google.com/file/d/0B1ApeEMIB_lNVG12aWVmVzdLS2M/view?usp=sharing I need to summarise data as show...
-
Find duplicate rows and copy content of one cell to new sheet [Closed]
Hello, I'm totally new to macros and excel. I have an excel spreadsheet with huge data in it (over 9lakh rows). There are many entries that are ex...
-
Macro to add number of rows correspond with number in cell [Closed]
Hello, I need a macro that can dictate the number of rows to add after a line based on the number that is in the column. For example: Actually...
-
EXCEL - blank or contains zero [Closed]
Hello, I am looking for the formula to solve this issue and return my answer in cell D: if the value in cell A is less than or equal to cell B th...
-
How to send an email automatic when a cell is updated [Closed]
Hello guys, I am imports coordinator I have a tracker created in excel worksheet which I use to track our shipments that arrive at port then proce...
-
Monthly Calendar/Daily Schedule Automation [Closed]
Hello, I am looking for some assistance outputting data from a monthly calendar to individual daily schedules. I inherited this project that initi...
-
comparing data among excel sheets [Closed]
Hello, I have three excel sheets with data regarding product numbers and their respective plants as well as another sheet (4th sheet) which is a t...
-
Finding the @ character within a text, cell range [Closed]
Hello, I can't seem to find anything that's specific to what I'm looking for. I'm trying to find a formula that will tell me the following: ...
-
Adding points from one sheet to another [Solved/Closed]
Hello, I'm trying to record points that students accumulate in a club. In a GoogleForm, I check off the students (Estudiantes) that earned x po...
-
date issue [Closed]
if my year is only 1991 and i am trying to input the date by default 01-01-1991 in excel how? Am just doing manually 1-1-1991 and the system automat...
-
convertions [Closed]
i want to convert dd-mm-yyyy to dd/mm/yyyy or mm/dd/yyyy
-
create a registration log [Closed]
Hello, I am trying to create a registration log for a campground. It would be of great benefit if I could copy the registration info to subsequent ...
-
Excel - A Macro to move data from rows to columns [Closed]
Excel - A Macro to move data from rows to columns Thanks to Venkat1926 for this tip! This Macro is working well for me, but with the exception of...
-
Macro to repeat x amount of times - next row [Closed]
I'm trying to wrote a macro which writes a csv from lines of data. Currently it roughly runs: Copy B3:L3 Paste in A2 (new page) Copy A22 Paste i...
-
copy data of 1 sheet to another if criteria matched [Closed]
Hello, 1 have 3 sheet master, damage & shortage. in master sheet if i enter in n column damage then full row should be copied in sheet damage also...
-
Selecting all colored cells VBA [Closed]
Hello Everyone, i trying to create a button that once i click it, all colored cells RGB (255,178,178) will be selected. i don't want to fill the...
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account