Forum
-
how to transfer data from sheet to sheet 2
Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that...
-
IF statement [Solved]
Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion...
-
Dynamically Assign a Number in Data Set
Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can...
-
transfer data from userform to sheet with the same format of table
hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in...
-
How to find the latest time per name in a table with names and times [Solved]
Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have...
-
Need to create linked sheets
Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is...
-
SUMPRODUCT Based on WBS
-
INTEREST ON TERM LOAN AND WORKING CAPITAL [Solved/Closed]
Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to...
-
get help Macro sheet
Hello, My name is vivekanandan i am try to create macro sheet like compare two different excel file and get the output in new excel file but i...
-
Spreadsheet help moving data
So I'm trying to make a macro that moves data from an input sheet to the appropriate sheet based on information in a given cell that is being...
-
Excel vba to color row based on wbs level
Hello I need a macro to change row color based on "Level" column. Thanks Ebti
-
Copy from one cell and paste to another sheet based on length of another column
Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy...
-
Summarise hours incurred by month based on multiple criteria [Solved]
Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below...
-
Creating Graph that updates
Hello, I am keeping track of how many work orders are being created each month. On my "Completed Sheet" in column F it has the due dates. I...
-
Are you still taking questions?
Hello, Are you still taking questions? System Configuration: Windows / Chrome 76.0.3809.100
-
Message to appear when 5 cells uncolored cells contain values. [Solved]
Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values....
-
Code to move rows into another sheet based on certain values [Solved]
Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data...
-
create an ordering list for our consumables
Hello all, New user here! I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an...
-
False Value removal
Hello, How to remove false value if I use below formula =IF($K4="Urban",IF(N4>0,1,0))
-
Checking the values in Sheet1 with multiple entries in Sheet2, Write the output
Hello Experts I am having 3 different sheets: In sheet 1, I have columns A- K & Sheet 2, I have columns A-G. I need to find column H values...
-
Creating a data input sheet with excel
Hi, So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is...
-
Count cells containing text per row
Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each...
-
Excel Formula to identify similar text
Good day, I am looking for help with an excel formula to identify similar text within two columns. In column A there will be a specific word...
-
Search using variable
Hello, I am trying to enter a value (name or partial name) and perform a search in the specified column. I can easily put a specific string in...
-
Auto-populate a sheet with data from different other sheets [Solved]
Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all...
-
Copy rows to other sheets based on value in column [Solved]
Hello, System Configuration: Windows / Chrome 75.0.3770.142 I have copy and pasted the code used to solve the problem for the question which...
-
transfer data from sheet1 to sheet2
Hello, i have data in sheet1 from range a1: f91 when i fill data and transfer to sheet2 it also transfer the empty rows here i wanna...
-
macro code vba exel sum dublicate data and delete
hi, everybody i need help code vba exel i have data in sheet1 begening from cells a2:g100 many data are dublicateed i would the sum...
-
Copy Template, Rename based on a reference list from a different spreadsheet
Hello: I am trying to make copies of a template in a worksheet, and rename those worksheets from a list on a separate worksheet. Currently my...
-
Replace 'sheet' reference in a formula (not copy data, but get averages) [Solved]
Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying...
-
how to merge bank statement into one column
Hello, how can I merge bank statement credit transaction with debit transaction in excel into one column? Considering credit transaction should...
-
Copying Excel data from one sheet to another based upon contents of a cell
Hi, I have a spreadsheet containing two sheets. Sheet 1 contains the following: Col A - username Col B - Full Name Col C - Email...
-
Am not too good on percentage calculation [Solved/Closed]
Hello please what is the 10 percent of,7200000000
-
How to duplicate rows x number of times
Does anybody know how I can repeat rows in a spreadsheet by n number of times specified in cell B in that row ie from this table: Column A,...
-
Follow up Q to how to add a certain number of days to a date in excel
Hello, Thank you for your article with the handy tip. What way would one make use of to fill the contents of a single row (or column,...
-
Macro to copy/paste down X times (where X is the number of rows) [Solved/Closed]
Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The...
-
Compare sheets macro
Can you please help me with the code for comparing two spreadsheets and giving the result in a separate sheet. The range may be different for the...
-
Which macro (of many) changes the data in my workbook
I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when...
-
Formula to subtract one cell value from another.
Hello, I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible? System...
-
Auto Transfer questioner with right answer to another sheet
Hello, I have questioner list (yes or no) about 60question. I want to make it automatically transfer (all the row) to another sheet if answer...
-
Insert Picture in Ms Excell
Hello Friends, Please help me out, how I can insert the picture in front of the name automatically. Means I just select the images these pictures...
-
partial matches in lists of 6-digit numbers
Hello! I have a list of ~500 6-digit numbers. They were all hand entered, and we want to proof the list and see if any of them were duplicated by...
-
Formula to create generations based on birthday [Closed]
I need a formula in excel that will indicate generations based off of a birthdate. Generations: Traditionalists (Prior to 1943) Baby Boomers...
-
Copy and paste selected cells a given number of times
Hello, I had a quick course on macro and I would like to write my first one, but I would need some help with it. Id like a macro which...
-
Send mail if today is the birthday. [Solved/Closed]
Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 ...
-
Comparing Two Excel Sheets and copying like data to third sheet [Solved/Closed]
Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1...
-
Getting multiple largest values with specified limits
Hello, a1 is 110,a2 is 236,a3 is 175,a4 is 352,a5 is 257,a6 is 175.In b1 find value is greater than or equal to 400.i need all answers numbers...
-
Extract data from few XML file into Excel.
Hello, i hope someone will be able to assist me, and i hope it is possible to do what i need. I need to extract specific data from a few XML...
-
COMPARING 7 COLUMN
HI I WOULD LIKE TO KNOW HOW TO COMPARE 7 DIFFERENT COLUMNS AND FIND COMMON VALUE IN NEW COLUMN I'M ATTACHING ONE SAMPLE HERE PLEASE CHECK...
-
Trying to insert multiple rows between rows in excel with copied data.
Hello, I have used the two listed vba macros but i am having no luck combining the two. First one to add 13 rows between current data: data is...
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD