Excel Forum
-
create worksheets with names from a list [Solved/Closed]
Hello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...
-
Finding terms in one word sheet & display on another word sheet [Closed]
I have two work sheets: Projects sheet that lists clients and the services we provided: A B C D ...
-
calculate percentage in excel [Closed]
Hello, My question is how to calculate 495000 kg main item scrap only 8 kg how to calculate in % figure
-
R, moving every other value in a column to a second column [Closed]
Hello, I have been tasked with manipulating the data ina a vector of 900 values in a form of a column. Every two values signifies a lenght and weig...
-
Integers in multiple rows to single row [Closed]
Hello all, My data set is like as follows: (All integers) ROW 1: 1 2 3 4 5 6 7 8 9 10 11 12 13...to 26 (26 cells) ROW 2: 27 28 29 30...52 (26...
-
Copy a set of cells and paste it 430 times [Closed]
Hello, In excel i need to copy set of cells and paste down 430 times. Any suggestions. Regards, Arunmaran
-
Keep track of hours [Closed]
Hello, I have a list of people and how many hours they have missed from work. Is there a way to sync this every day with the new data which might ha...
-
Get Mirrored Column "Structure" in 2 Sheets [Closed]
So this turned out to be a complete mind-breaker for me. Thanks to the help I previously received on this forum I can already manage (and enjoy!) q...
-
Help Please IF & VLOOKUP Returns [Closed]
Hi, I'm trying to use the following formula which works however I can have more than one number which is the same e.g( B2 can be in the TOPWE tabl...
-
Transfer, populate and calculate data between excel sheets. [Closed]
Hello, I want to be able to input data daily onto the first sheet of my excel file for six different things. I then want to have a separate sh...
-
incrementing the column at regular intervals [Closed]
Hello, I need to increase the cell range at regular intervals using macros. My code is: Do While Cells(2, m).Value "" Range("cells(2,...
-
Hide Zero Rows or Zero Columns in a Worksheet [Closed]
Hello, I would like to know if there is VB code out there that solves for Hiding rows and Columns that show either zeros across the rows or the ...
-
Excel - Merge several worksheets into a single one(thanks) [Closed]
Hello, I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge...
-
How to filter out data to separate sheet? [Closed]
Hello Guys, Can someone pls help me out with this problem I am having. I have 5 drivers on payroll for a car service company. I have all the a...
-
file attachment [Solved/Closed]
Hello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...
-
check info on two different cells... [Solved/Closed]
Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...
-
Disable right click on sheet tabs in excel (MAC) using VBA code [Closed]
Hello, I am looking for a VBA code to disable right click on worksheet tabs in MAC excel. Application.commandbars("Ply").enabled=false is not ...
-
How to restrict user from deleting a sheet? [Closed]
Hello, I want to restrict the user from deleting a sheet using vba code. I dont want to protect the sheet. Is there any option to protect the s...
-
Macro auto run on file creation. [Closed]
Hello, I have an excel file created automatically every day, I want to be able to run a macro against the file when it's opened. I can automat...
-
Write data if a text is found in that colomn [Closed]
I want to write some value if A text String in Cell A is present in another colom and if found then I want to write the value of that row in front of ...
-
compare data from one excel sheet to other [Closed]
Hello, i should compare data from one excel sheet to other, please help me to solve the issue. Configuration: Windows 7 / Chrome 45.0.2454.101
-
Random sorting without adds-in [Closed]
Hello, Is there any way to random sort without using random sorter add-ins? I just want to random or shuffling the row just like the pic. ...
-
conditional formatted cell with specific colours should copy in [Closed]
Hello, i got live data from web. i had given some condition to each row if the values are higher or lower when comparing with specific cell. i had...
-
my enter keys and arrows stop working in Excel. what can I do [Closed]
Hello, My enter keys and arrows keys stop working in Excel, what can I do to fix this problem/ Thanks for any help. Configuration: Windows / Ch...
-
auto transfer data as i marked [Solved/Closed]
Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...
-
Populating Sheet Based off date criteria in another [Closed]
Hello, I have a database that I would like to auto populate all of the 2015 events into a 2015 sheet. I need the data in both sheets as the main i...
-
Range Formulas [Closed]
Dear All In Ms excel column "A" is names of 30 staffs, column"B" is dates, column"C" is amount I paid to them, Now total number of payment is abou...
-
Pulling data from different workbooks and collating on another [Closed]
Hello, I would like to be able to do the following; have a number of work books which are allocated to team members (x4) which they complete with ...
-
Counting action under condition of theyr value, and month when.. [Solved/Closed]
Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...
-
Editing a date+time field converts date to text [Closed]
Hello, I have formatted a (Excel 2010 spreadsheet) column as "ddd\ dd-mmm-yy\ \ hh-mm\ \h\r\s" which shows the existing data as "Sun 04-Oct-15 ...
-
Comparing Spreadsheets [Closed]
I have been given a task in Excel and i am not good at it. I have two different spreadsheets with first and last names in them. I need to compare sp...
-
@if formula [Solved/Closed]
Hello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...
-
Change text value in one cell based on text value in another cel [Closed]
Hello, I was wondering how can I change text value in one cell based on text value in another cell by using the conditional formatting? For exa...
-
i want to plus data from two excel sheeets to the third sheet [Closed]
Hello, hi Configuration: Windows XP / Firefox 38.0
-
Cell formating [Closed]
Hello, I have excel sheet that contains 1000 rows of customer and i need to change color in one cell based on anther cel in same row ,this i solv...
-
conditional Formating a column [Solved/Closed]
Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...
-
Find words within cell & put value in adjacent [Closed]
Column has Organisation Name Need to Search and Create a category to the next 5 columns A Organisation can have key word in more than 1 category...
-
Help Request - for Advanced Filter Macro VBA [Closed]
Hello, I would like to have data from my master sheet to another one based on multiple criteria filter. My master sheet can be manually filled and ...
-
Copy cells based on conditions [Solved/Closed]
Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...
-
Comparison of Cells [Closed]
Hello, I want to compare two different cells in two different sheets and print the same in third sheet. 1) For Example in sheet1 is P and sheet2 is...
-
VBA macro to color a range of cells based on value of other cell [Closed]
Hello, I' am using a shared file and hence could not use conditional formatting. I want range C2:F2 should turn Blue is the value in cell G2 is...
-
Another Excel macro copying cells based on criteria [Closed]
Hi Excel Virtuosos, I've really been scratching my head over this one. I'm compiling a summarised history of a project since its conception 7 years ag...
-
Automate some of my daily Activity in Excel using Excel Macros [Closed]
Hello, I am a Hyperion technology Person. Looking for Vbscript code/Excel Macro code to automate my daily job. Before Looking for help on this, I wo...
-
Copying data from workbook to workbook using button [Solved/Closed]
Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...
-
Change color to different cells based on another cells text. [Solved/Closed]
Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...
-
Need to find multiple Words to I Category (column) [Closed]
Apple, Pear, Peach example in one cell to be dragged down to 10000+ =IF(ISERROR(SEARCH("*apple*",A1,1)),"","Category ")
-
Auto notify or mail when excel sheet updated. [Solved/Closed] [Closed]
Hello, I have used following VBA, but still I am not getting the solution. Please help I am unable to change the following field. answer = M...
-
Unable to get email notifciation [Closed]
Hello, I have placed below noted in my excel. but I am unable to get the email to my ID. Please help me Private Sub Workbook_BeforeSave(ByVa...
-
Excel Workbook [Closed]
Hello, I have a workbook with over 100 sheets. One of the sheets has a title of labels, I am trying to set it up ina way that if i type in sheet 10,...
-
Copy cell, unless another call says specific text [Closed]
Hello, In my spreadsheet, currently C1 copies the number in A1. (=A1) I need this command to be overridden if B1 contains the text VISUAL Tha...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Install a VPN
- How to Create a Gmail Account