The discussions
Autopopulate using dates
Kind of a complicated one. I'll be appreciative/extremely impressed if someone can help me out. I'm budgeting and trying to autopopulate cells usi...
How do i create this conditional formula
How do I create this formula? If A2, B2, and C2 has a combination of H, H, HP (it doesn't matter what order it is in), returns a score of 98 in cell ...
What formula can be used to share data in 2 sheets
Hello, I have two excel sheets A and B having the same columns. there names, dates, figures. not necessarily having the same number of rows, havin...
Conditional formatting
I wondered if you could assist please? I currently have a column of dates that change to a bold red if the date is past. However, I require the date...
How to use a macro to check data in 2 work sheets
SolvedHi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...
How to generate a static unique identifier for each excel row
SolvedHello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...
Two if forumlas inside an if formula
SolvedHello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...
Formula with varying information need pasted multiple times
Hello, I have what may be a simple issue. I have a spreadsheet that I need to apply a formula to in certain fields. One formula may need to be =...
Master sheet to affect multiple sheets
Hello, I am not sure how to explain this... I have a master sheet that has a list of all the names and grades for each row alphabetically. I have ...
How to find grade
How find grade in excel, old tell me about the formula
Autopopulating multiple sheets from one main sheet
Solved/ClosedHello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...
How to sum a number from a range of cells, based on value
SolvedHello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....
Subtracting numbers based on data in another cell
I use a cell to show that a number has been deducted from an account. How can I make a subtraction of that amount form a total amount based on the inp...
Name check
Hello, How to check the name with two cells. if any part name matched with second cell, it have to be show as TRUE. What formula for this?
Self-generating sequenced number each time a sheet is opened
How do you create a ( for example an invoice) self-generating sequencing number so every time an excel sheet is opened it will generate the new number...
Rank of numbers between specified range
SolvedHello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...
Paste x times with multiple conditions
Hello, I have no real knowledge of macro, but I think macro has a solution to my question I have data in Sheet1 and would like output in Shee...
Formatting cells based on certain criteria
SolvedI want to make a cell change colour based on a number of different criteria: Cell A1 Has an incident date B1 Displays the date 14 days after the inc...
New tab copy paste
Hello, Being extremely new to VBA I am trying to create a macro that Creates a new worksheet and then have it copy and paste data into the new works...
Save as in a macro
Hi i am trying to save a copy of my workbook ie p&l report plus the date so i can save it each week, so far the macro i have will print all info and c...
Creating macro for auto updating multiple workbooks
Hello, I have been assigned a daunting task to create multiple reports(5) for specific clients in one workbook. This project is large as there ar...
Need help with a macro that can copy and paste last 10 active da
Hey Guys, I am a newbie to these Macros. I need desperate help from the EXPERTs. A few things I need for my macro are: 1. I have multiple d...
Attendance log help
Hello, I have an attendance workbook I am working on and need to make different worksheets according to age. I have everything entered into the fi...
Copy paste rows from one sheet to another n times.
Hello, I need help with Macros. I have my primary data(seeking production schedule) on sheet 1. I will have 100-120 rows Of data. Column A(no of ...
Find matching data in two worksheets and copy entire row
I have one sheet that has about 350k rows and columns A-AW. Column Z contains phone numbers. I have a second sheet that only has phone numbers (about ...
Sum ifs function
SolvedHello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a co...
Excel macro: copy formulas across worksheets
SolvedSo first off, I have no Idea how to program, but I can kind of understand simple programs. Either way, I'm trying to figure out a macro in MS Excel...
How to get b column value against a column
Hello I have 3 columns like A B C D 1 2 5 2 5 4 3 9 2 4 8 1 5 7 3 Now I Will Compare A And C Column...How To Get B Column Value...
Formula search keywords in multiple columns
Hello, I need to find a excel formula (column A) to track keywords in a table with multiple columns. the key words are for example Accor F...
Help : copy paste to end of list without formatting
Hello everyone :) System Configuration: Macintosh / Chrome 60.0.3112.113 I'm new to Macros in Excel so I really need some help. Basically I ...
Enter value in cell, have range of cells copied to another sheet
Hello, I have an materials list spread sheet that when I order a line/row, I'd like that row with the amount ordered to transfer to blank sheet 2. ...
How to do a macro in excel with random pics?
I need to do a macro with random pics. When in column "K" in scheet "SHEE4" find word "OK" then replace or paste in next cell random image from folde...
Arrow keys scrolling in excel
Solved/ClosedHello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do not...
Help with formula please
SolvedHi, please could someone help me with a formula to add up cells that have data in them. My spreadsheet has data in columns B-N - some of them have ...
Criteria dependent data transfer.
Good Morning, I would really appreciate some assistance with regards to a workbook I am creating in Excel 2010 to track equipment movements. I have ...
Subtract last column from first column
Solved/ClosedHello, I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last colu...
Merge 3 general cells to one date cell
Hello, I made a mistake formatting my HUGE tour schedule. I thought I was so smart using 3 cells for dates a1= 10 (for 2010), a2= month 1-12, and a...
Bank reference changed format help
Hello, I am trying to reconcile some standing order income at work, we have changed bank account and the reference has changed format! The process...
Need help with data sorting & updation
Hello, I have a sheet with 6 coulmns each with (ABC & DEF) some value and different data Column A & D have same values. e.g. A B C D E F I want...
If then else
Hello, Please help me with a formula for Excel(?) in Open Office. I want to say....If =IF(G59=date;then_date;otherwise_0) I am trying to say i...
Filters for rows label coming as (blank)
Hello, I ran a Pivot on office2013 and some reason my filters for Rows label coming as (blank) Any idea?please? System Configuration: Windows /...
Need to calculate monthly avg and yearly miles from odometer
Solved/ClosedGood afternoon, I am having an issue figuring out how to get excel to calculate the yearly mileage and monthly avg by just monthly odometer reading...
Auto-populate info. from master sheet to multiple sheets
SolvedHi, I have been working on an excel sheet for the past month and have not found a solution that would do what I need it to do. I'm sure there have ...
Enter data into main worksheet and have it update separate ws
I have a workbook that I would like to enter all my data into one main worksheet "2017 Job Cost Analysis" and have that data automatically populate al...
What will be the formula
Hello, if A1>A2 THEN C1+C2 AND IF A1
Lock a cell based on another cell in the entire sheet
Hello, I have drop down selection (Yes/No) in Column A, and I need to lock corresponding cell in Column B if the result is "No" in Column A. Please ...
Date of brith in words 05/06/2016
Hello, date of brith in words 05/06/2016
Update data from one sheet to the next.
SolvedThe macro I want just takes data from one tab and adds it to another like an update. i suspect that the macro will take some time to make as the updat...
Transfer activity data to new sheet with yes/no criteria.
Hello, I need to prepare the excel summary with the help of Master sheet. If the drop down in master sheet is yes, than that option should be copy...
Want the coding to paste some data to another sheet
Hello, I want to copy one data to another sheet. But I want the data to be pasted one after another as many time I submit it System Configurati...
