Excel Forum
-
Excel macro to create dropdown value of the sheet and values [Closed]
Hello, I have spreadsheet containing multiple sheets and values in it. I would like to make a macro tool to create a dropdown button of the sheet a...
-
Excel - possible to populate fields using a hyperlink? [Closed]
I'm creating a job tracking workbook, with a master sheet on page 1. Additional worksheets are used to list activity on the job. From sheet 1, I am cr...
-
Auto Transferring Data from one cell/row to another sheet [Closed]
Hello, Good Morning. I have a list of transaction in one sheet. With a column showing the sheet name where the data of that row should be trans...
-
EXCEL 2013 Compare Column A to Columns B,C,D [Closed]
Hello, I am trying to Compare Column A to Columns B,C,D and put location of match in column E. Is this possible? Configuration: Windows 7 ...
-
Change cell colour based on values in other columns. [Closed]
Hello, I would like to change cells in column C base on numbers in Column A and B. So for example, A1=3, B1= 1, C1= Red A2=2, B2= 2, C2= yellow ...
-
copying columns of data on multiple sheets in another worksheet [Closed]
Hello, I have a master budget with a summary on one worksheet, and department budgets on subsequent sheets. When there is a number on the summary sh...
-
Need a Macro to Copy a Sheet and Populate from a List [Closed]
Hey there! I'm new to using macros on Excel, and I've been having some trouble. I have a sheet called "Rating Plate Template" which has been sized ...
-
How to automatically update data from one sheet to another [Closed]
Hello All, New user here. I have tried to research an answer to my question to no avail. I have found similar situations and solutions, but not o...
-
Macro: compare 2 wkbk, paste un-duplicate code in the 3rd wkbk. [Closed]
Compare 2 workbook and paste the non-duplicate data in the third workbook in an empty cell.
-
Index , array and need help with print [Closed]
Hello, I have a database and I created a form using this database . I used "index" syntax and it works but my problem is I need to print this form...
-
Automatic data transfer [Closed]
Looking for a excell expert Is this possible? I want to transfer multiple cells Of a worksheet to another sheet in the same work book with a single ...
-
Cannot browse - ftp ok, email ok, ping ok [Solved/Closed]
Hello, I have been following the thread from people with similar problems but mine is not fixed. This all happened yesterday when AVG falsely ident...
-
Automatic data transfer [Closed]
I want to transfer multiple cells Of a worksheet to another sheet in the same work book with single click. This is a work schedule of jobs and I'm w...
-
Date format [Solved/Closed]
Hello, i have a column in format like 14-02-14 and i want to change it like14-02-2014
-
if condition formula required [Solved/Closed]
Hello, Thank for the earlier reply. Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. ...
-
I need to make a macro with many difficult functions [Closed]
Hello, I have a basic understanding of macros, but I have never written a macro, or developed something of this complexity. The user of this ma...
-
Comparing two cell values with a range of values [Closed]
Hello, Hi, I have been seeking out for a solution for a problem. I have tried a couple of formulas like VLOOKUP, INDEX.. MATCH and nothing seemed...
-
if condition formula using dates/no. of days in the moth [Closed]
Hello, I work for a financial institution and looking for a formula with IF condition.If i collect that month installment, It should reduce the no ...
-
How to copy data from one sheet to multiple sheets using IF [Closed]
Hi, We have one sheet were the master data is entered. There are different users who input data on this master sheet. How can this data be copied o...
-
Excel Consolidation Tab [Solved/Closed]
Hi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...
-
Customer Protected Form and Posting my data into [Closed]
I have a customer who sends me a Excel bid form that is protected and they want us to enter our price, manufacturer name, catalog number and delivery ...
-
Excel Formula to add DAY in cell from DATE [Closed]
Hello, Is it possible to have a formula that automatically adds the day to a cell if a date is entered into another cell. For example, Column A...
-
If cell A1 has text then cell B2 has today's Date [Solved/Closed]
Hello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...
-
Excel date format change [Closed]
Hello, I have use MSoffice-2010,in a excel sheet there is some data with 72 rows.Main issue is when I sent the excel sheet to my friend he got the ...
-
Programme to automatically populate XL Spread Sheet [Closed]
Hi All, Im doing audit for diving equipment. All data will be compiled in 1 excel file with several sheets. 1 - Record of Inspections - NC 2...
-
Problem with arrow "up" key in excel [Closed]
Hello, I am having difficulties when navigating in my spreadsheet. All works fine except the arrow up key. When pressed it moves to the cell above...
-
Some change in vba code [Closed]
Hello, Here is my code that change column color base on another cell color, i want a that change row cell color with Yes value base on another cell c...
-
Merge Cells that have to same data in Excel! [Closed]
Hello all, I'm new to the 'Corporate Level' of Excel, so I could really use some help. Here's my situation. I was given 3 spreadsheets. The first ...
-
Comparing two excel sheets [Closed]
Hello, i have 2 excel sheets, each with 2 columns name and email. the scenario is i want to compare both sheets and display those which has the same...
-
Conditional Formatting in multiple column [Closed]
Hello, I have done conditional formatting in column D (if duplicate value found then cell color will be red), now I want the respective row cell t...
-
Excel - Repeat rows a specified number of times [Solved/Closed]
Hello, I'm aware of the post here https://ccm.net/faq/7546-excel-repeat-rows-a-specified-number-of-times But I would like to just type a num...
-
how to repeat rows by x number of times [Solved/Closed]
Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row ...
-
Macros to copy multiple data from 1 sheet and saving it on anotr [Closed]
Hello, I would like to enter multiple data on sheet 1 and copy and update the data on sheet 2 by running the macros. This should work for foll...
-
Highlight Jobs that are due. [Closed]
Not even sure where to begin on this one and not sure it's possible either but thought it's worth a try. I have a document to record date's when jobs ...
-
add data from a template exel file into a master excel database [Closed]
Hi, I Have basically a template which I use for export, as shown in example below My template columns A,B,C layout are like: A ...
-
excel 2003 question. on conditional formatting using VBA [Closed]
Hello, i have been trying to figure out how to make my code stop bugging out on me. any and all help will be greatly appreciated. Option Compare ...
-
Excel "IF" formula Help! [Closed]
Hello, Here is a Microsoft excel question. I have a column with words in it. The words will change depending on what the row next to it say. The col...
-
ROUNDING FUNCTION [Solved/Closed]
Hello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...
-
How to stop Excel error message for too many data points? [Closed]
Hello, When trying to create a chart with information trending over a long period of time I keep receiving this error message: "The maximum nu...
-
Conditional Formatting [Closed]
I have a document in excel where I want to change the colour of a number of cells based on information in one. So I'm guessing a formula will be neede...
-
. [Closed]
Hello, I have data like this.. YTQ5478568 WBH548567 XML8457693 I need like this Y T Q 5 4 7 8 5 6 8 W B H 5 4 8 5 6 7 X M L 8 4 5 7 6 9...
-
VBA to refresh all pivot tables [Solved/Closed]
Hello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...
-
Massive Copy/Paste..can it be done? [Closed]
I am working between to separate excel files. Basically, I'm hoping there is a way to copy and paste OR ever better a way to auto insert fields to ano...
-
Macro to add/remove rows based on highest # in group of cells [Solved/Closed]
I am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....
-
Insert row data on Sheet2 based on sheet1 cell value(text) [Closed]
Hello, i have two sheets i.e., sheet1,sheet2 in Sheet1 row fields like A B C D E in that D field value like RC based RC value insert whole RC ...
-
Search Multiple Sheets of a Workbook & Copy the Results [Closed]
Hey, So I have a problem and I can't seem to find a similar question asked before. I have an excel workbook with 10 sheets. Each sheet is rega...
-
Excel - a Macro for copying data from different sheets [Closed]
Hi, I love your posting. I was just wondering if I could exclude some tabs from being copied. I am pulling information from pivot tables so I hav...
-
If text encountered, add rows [Closed]
Hello, I would appreciate any help on a worksheet of thousands of lines of data I get and must format every week. Whenever the text "-C0" is enco...
-
How to add a number every two weeks in Excel? [Closed]
Hello, I'm trying to come up with a formula that would automatically add a number in a cell every two weeks. Any help is appreciated. Configu...
-
How to match 2 lists to get the unique entries [Closed]
I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the en...
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- How to Install a VPN
- How to Upload High Quality Photos to Instagram