Excel Forum
-
Need Help with Formula [Closed]
Hello, I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I input manually a productivity number daily. On c...
-
Copying an adjacent cell text from another sheet, if cell exist [Closed]
Hello, I have 2 excel sheets with lists (+5000 rows) of unique parameter names (text) on each row starting from A2. Sheet 1 has only the param...
-
formula for copying figures onto another sheet when value is >0 [Closed]
Hello, I would like to create a formula that will only show figures from another sheet that are greater than 0. This is for an invoice template. T...
-
Excel Macro [Closed]
Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after each category. I want the second blank row t...
-
COMPLICATED EXCEL FORMULA [Closed]
Hello Friends, Can any one help me to sove my problem. I have two excel sheets . i want to comapre column A and B with other sheet and if both cell...
-
Macro Copy & Paste same Cells Down [Closed]
Hi all, First off, I'm new to macros so just a warning. I am currently working on a simulation, and trying to create a macro that will record th...
-
Copy from one sheet to another based on value [Closed]
Hello, I am a newby to excel macros but here goes. I have a sheet where raw data is being entered in rows called DATA (How original) :-) I have...
-
Compare two Excel Sheets which have Duplicate Values (Advanced) [Closed]
Hello, I'm trying to compare two excel sheets which have duplicate values in the matching column. In both sheets the number of row count is dif...
-
Fetching of data from number of other sheets to a master sheet [Closed]
Hello, respected consultant, I have created a Excel Sheet for student class attendance. in it i have made a provision for over all attendance of ...
-
Cut-Paste from 1 Workbook to another-based on cell - del columns [Closed]
I have a master workbook and a template workbook. Master workbook has 6 col - Vendor / Rep / ST / Code / Amount / Name. Template has 5 col - Vendor ...
-
Moving Entire row from one sheet to another [Closed]
Hey, I have a list of job orders listed in excel. One job takes one row. One of the columns reads heading as "Job status", the value under job status...
-
Urgent Copy Vertical data from One sheet to another horizontally [Closed]
Hello, I am trying to copy cell data from one sheet to another, the data in source sheet is vertical and i have to copy horizontally in destination...
-
Pictures pasting over each other....Help [Closed]
Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...
-
Get a value from Col A based on the max value found in Col B [Solved/Closed]
Hello, Get a value from Column A based on the max value found in Column B display in Column C. I need to get value Jill in Column C. Name A...
-
From iPhone to excel [Closed]
I need a button in excel where I could import I photo I am taking into an assigned cell. I will need to do this multiple times in a spreadsheet. Is t...
-
Check Options in Excel [Closed]
Hello, I would like to request that Questionnaire is design in which (ranges from A5 to E1000) Column B Contain Excellent Column C Contain Good...
-
Format cell's currency [Closed]
Hello, I am working with a drop down list that includes 7 or 8 account numbers to choose from through data validation. Various bills are paid from...
-
Comparing dates in multiple columns and using one that matches [Solved/Closed]
Hello, I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and depende...
-
how to convert date into words(marathi) [Closed]
Hello, i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 o...
-
Macro to insert a number into cell A11 for 180+ excel files? [Solved/Closed]
I used the macro below to merge a bunch of files but it cut off the last row of data. It looks for the first A cell with nothing in it to end it and t...
-
Auto populate into a different tab based on cell value [Closed]
Hello, My job involves tracking several POs for several different vendors. I am looking to compile several sheets of data into one workbook with d...
-
Column Matching and Data Pulling [Closed]
Hello, I am looking for first, for two columns to match, let's call them A and C, if they match, I want Column D to have the same vaule as Column ...
-
Create & name worksheets from a list and copy data [Solved/Closed]
Hi Guys Really new to this and thanks to previous posts on here I have managed to create code to complete the first part of my jigsaw, just struggl...
-
Copying data with respect to a condition [Closed]
Hello all, I suppose the problem I have is not a complex one. Here is a brief intro to my work sheet A B C D ...
-
copying specific range of datas [Closed]
Hello, I suppose the problem I have is not a complex one. Here is a brief intro to my work sheet A B C D E F ...
-
How to write a macro to lookup rows [Closed]
Hi, i have 2 worksheets with hundreds of thousands of rows of cost centers. I would need to do a lookup of Cost Centers in worksheet 1 with workshe...
-
how to change to infilll colour of one cell according to another [Closed]
Hello, I am hoping some one can help me, I have started looking to set up a database regarding dates for training, it is dynamic changing the date a...
-
Macro - Create new sheet and generate information from Summary [Closed]
Hi all, Just wondering if someone can assist, I need to create a spreadsheet that has a running list of service calls (Summary) then once a line is...
-
VBA Macros Help [Closed]
Hello, I have a need to create a macro that is beyond my knowledge. I recently started trying to learn how to write simple macros in order to simp...
-
Multi Copying Excel 2013 [Closed]
Evening All I looking to copy the same lines of excel * so many times depending on number in a column. So anything input in A2,B2,C2,D2 is cop...
-
Help needed to compare excel worksheets. [Closed]
Hello, I have an Excel worksheet that contains a list of part numbers that I stock. I also have other worksheets that contain lists of parts that ...
-
Middle name extraction [Closed]
Hi, I need to extract middle name from full name. for some case its working but in those names without middle name, it throws #VALUE! error. also ...
-
Formatting whilst using letters and numbers [Closed]
I would like to conditionally format a spreadsheet based on grade progression, where the grade contains both a letter and number. The grades are n...
-
Conditional format make a row a color based on another cell [Closed]
Hi, I have a large spreadsheet with many rows and columns. I want to color a row green when we have been paid on that line. There is a column ...
-
How to insert columns until a cell condition is met [Closed]
Hi everyone. I'm not very good in macro and hope that anyone could give me some pointers. I have a worksheet (ie. Project A) whereby it contains he...
-
Paste data from specified cells to another when just typing comp [Closed]
Hello, Hello, I am trying to use macros to copy data from several cells into different cells in another sheet. My data is consisting of Organizati...
-
Macro to get random samples based on condition [Closed]
How to create a macro which picks random 200 rows from a excel file which has huge data. Each column containing both empty and valued data.
-
If cell contains a word from a word bank, then return value [Closed]
Hello, I need to be able to read a cell and see if it has any of the following word: John Jane Jake Jill Jack ect. Then return True on an...
-
Find the net elapsed time of a task [Closed]
Hello, I need to calculate the effective time taken by a task. I have the start date&time and end date&time of the task. Both the times are mai...
-
Macro-not refering correctly [Closed]
Hello, Iam very new to macro, i have written a code, that should work in sheet 6, but it always by defualt goes to sheet 1.Please find code below: ...
-
finding percentages [Closed]
Hello, I'm not sure if i'm asking my question in the right place or not. I need to find percentage of attendance for a period of time. I have...
-
Cell referrence [Closed]
Hello, How can we referrence a particular cell value in date formate in another cell which has a multiple number? Thanks
-
Lookup 2 cell headers one one sheet to find answer on another [Closed]
Hello, I am trying to lookup the employee name and week # included on sheet A on sheet B in order to find the % of utilization during that week. ...
-
Need only date from text [Closed]
Hello, how to get only date when a cell contains text. EX: MON 12/20/1968 12:30 . I want only the date 12/20/1968
-
Populating many sheets from one [Closed]
Issue: I'm working on a Google Excel doc which is being populated by entries on a Google form. Each row on the sheet relates to one form entry. ...
-
Get value from cell to other sheet based on condtion [Closed]
Hello, i have sheet with lot of data . i want to get some value of my sheet to other sheet in excel . for ex: Cell A | Cell B ==============AB ...
-
Excel function [Closed]
Hello, I need to auto populate the text in column A into another sheet if the adjacent cell in column B is a certain number. Configuration: Wi...
-
Issue in Excel [Closed]
Hello, i am unable to change the date format in excel... actually it show 42625 but while "F2: 9/12/2016 can you please help me to resolve the iss...
-
If text, return a date [Closed]
Hello, Having difficulty here. I have a monthly table (Jan - Dec) with varying text starting is varying months. I want to highlight this arr...
-
Excel Dates [Closed]
Hello, so how would july 7 1999 be written Configuration: Windows 7 / Chrome 53.0.2785.116
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- How to Install a VPN
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account