The discussions
Insert picture in excel macro which takes the file name refrence
Hello Friends, Kindly help me! I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert th...
Formula for text in a cell and then total the amount on text
Hello im trying to total the shfit allowance on timesheets eg: In cell k7 they will leave blank if not claim shift allowance, but if they are then ce...
Change value of subsequent cells once a condition is met
The simplified story: I have a user input "Start Month" that is between 1-12. I have Columns A:M labeled accordingly 1-12. The question: If the us...
Vba to automatically insert subtotals in multiple worksheets
Good Day, I hope somebody can help me, I have an workbook with a main sheet ""2017 Sales" and 10 worksheets with the name of each individual sales Age...
Open workbook using following code
Private Sub CommandButton1_Click() Workbooks("Patch.xlsm").Activate Sheets("Site Name").Select S = Range("A1:A2") D = Range("B1:B2") E = Range("B...
Database copy only certain information
Hello, I currently have a table with data containing peoples information for a sports program, I would like it if I put "Yes" in the coloumn for the...
Search a list of names at one time in excel
SolvedHi, I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B . Is i...
Autofil random cell in another worksheet
Hello, Please help me write the code for below situation: 1. I have 2 sheet "Merger_Pole" and "Config". 2. In Merger_Pole, I set F2=Config!C29 (ra...
If a cell contains any text then add a value (with dates)
SolvedI am looking for help with a formula that will allow me to add up the number of times a certain date is a Monday. I am using =COUNTIF(A1:A30,"*Monday...
Macro to increase a cell reference by 11
SolvedHi everyone I want a macro that on open will increase the cell reference in a cell by 11 each time the book is opened i.e. Cell C18 has =Sheet2!H2. T...
Totaling ot hours on separate sheet
Good Morning! https://drive.google.com/file/d/0Byqv0sZOGZaHRUNuUlNUc1RKbWM/view?usp=sharing I have a spreadsheet that managers fill out with overtim...
How to access open office software
how can i access open office software
Automatically transfer rows from 1 sheet to another using a comm
Hello, I am very new to excel codes etc... I have a spread sheet that I would like to automatically transfer rows from 1 sheet "Current" to anothe...
How do i change a word doc into pdf or similar file format
SolvedWant to send off a resume and they do not accept my covering letter in Word format, how do I change it to PDF or similar please
Mac os, big file split data into seperate worksheets
Hello, To begin I require a rather large Excel (.csv) file to updated every 2 days. This file consists of roughly 23000 records and spreads from the...
Creating a formula if a cell is equal to or less than 7.00
Hello! I am looking for a formula that will do the following: If a cell is equal to or less than 7.00, the entire row which contains said cel...
Microsoft office word office open xml file hmc 10 cannot be open
the office open xml file hmc 10 cannot be opened because there are problems with the contents how to fix this error. I tryed lots of solutions to fix ...
Conversion of dob to full words
SolvedHello, Configuration: iPhone / Safari 4.0 I want to to convert dob to word like 5/6/2014 to fifth June two thousand fourteen please tell me...
Data auto change on multiple status in one column
SolvedHello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...
Master sheet auto-populating anniversary dates into new sheets?
Hello, I have a master sheet that has our employee information and start dates where I have broken up their start dates into different columns for t...
I want to create spred sheet
How do I open excel? -- Karen Deeter
Repeat row x times
Hello, I want to make some labels for products. i have a sheet with info in columns A-F(name, sku, size, description, date, and quantity. Column F...
How to sum responses from cells with list data validation
Hello, I want know if it is possible to total (SUM) the number of responses I have on cells which have the data validation. I have set up a sprea...
Question on vba code
SolvedHello, can someone explain this code to me? I have this file that has a macro button transferring all the information(KPI's to be exact) from a data...
Excel - repeat last row into n number of times
Hello, Can anyone help me to repeat last row into N number of times into same sheet. Sample Data Where N=5 Column-A Column-B abc 111 AAA...
Please help excel 2016
Hello, I have an excel workbook for our call center metrics and i need to accomplish the following On the sheet named calculations and a sheet nam...
Unable to display pic in mac platform
Hello, Please help me to solve this for my project ...need help as soon as possible Already Macro enable,picture display issue message is "The Link...
Formula help - if cell contains a number, +1.
SolvedHi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...
Covert date of birth
SolvedDear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...
Need help with macro to generate monthly overview
SolvedHi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...
Conditional formatting
SolvedI am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...
Update cells in a particular column from one sheet to another
How do I update cells in a particular column from sheet to sheet. I have a payroll worksheet and occasionally our employees borrow money, I need to co...
Countif statement driven by spesific date and text criteria
Hello, Employee Work Code Report I need to summarize every occurrence in column C within each of the same dates in column D (1/1-1/31) and based ...
Formula to completed fields
Hello, I need a formula to look up values that if it shows all false it's a green light and if it contains at least 1 true value, it's red light. I...
Timesheet adding rows
Hello, I'm trying to work out a formula so that I can hand off my timesheet to a new manager and have it work correctly. Right not I sum a row of to...
Unable to display pic
ClosedAlready Macro enable,picture display issue message is "The Linked image cannot be displayed. The file may have been moved, renamed or deleted. Verif...
I forgot my gmail account password
Hello, Send a password on my main account. System Configuration: Android / Chrome 56.0.2924.87
Transfer data from one sheet to another
SolvedHello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...
Look up a word within a sentence and copy into a next column
Hello, I have an excel file with over 10 000 entries, each entry contains a city within the sentence - I also have a database (another sheet) with a...
Date formats
SolvedHello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...
Complicated auto populate possible or not and if so how.
SolvedHello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...
Compare columns in two sheets and copy info across
Hello, I have two sheets open. Sheet 1 has two columns of data (PO number, Value) Sheet 2 has two columns of data (PO number and supplier) What ...
Copy row by x times where value x is cell value of the range
SolvedI need to scan each value in a column A and use the value in that column to copy the current row x times to another sheet. The second sheet is to be u...
Formula for assigning numerical value to text
Hello, I have a very large excel sheet with names. Some of the rows of names duplicate, sometimes more than once. In each row next to the name is a...
Code to check if a work centre on sheet 1 appears on sheet 2
Hi, Please help me write a code that will check if a work centre on sheet 1 appears on sheet 2. If it appears in sheet 2 the work centres in sheet 1 ...
Iso 27005 risk value
SolvedHi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...
Index & match
Hello, I would appreciate help on the following:- I have 2 excel sheets both set out as Tables (Table 2 and Table 3). Table 2 has 4 columns A B C D...
