The discussions
Simple date subtraction excel
Solved-It seems soo simple, yet I haven't been able to find the solution. I need to display a date that is five years in the past from today. -I tried a co...
Add date function to this code
SolvedHello all, I am looking to add a date function to cell J (or whatever column/cell I need it to be) after this code performs its actions. Currently ...
New version v-tools available?
Solvedv2016_183 was great, however is there a version for Access2021-64bits available?
Download odbc drivers 64-bit for access
SolvedHi, I need to download 64-bit ODBC drivers for Access Thanks
How can i start a spreadsheet at windows login.
SolvedHello, How can i start a spreadsheet at Windows login. The normal simple way does not work. Thank you, Mondriaan
Adding buttons to an excel spreadsheet.
SolvedDear CCM Team, How do you add a button on a particular cell in an excel spreadsheet to turn it on and off. Example: If I want to add a column of nu...
Pop up message in excel (like outlook agenda)
SolvedHello, I have a big file in Excel with heaps of information about my customers. One of the coloms is telling me when I need to send them a letter....
Monthly production report -automatic transfer of data
SolvedDear All, I am looking for a solution to generate monthly production analysis report of an operator for his daily production. Attached sample sheet...
Print 1 document in a5 size - change doc size to a5
SolvedHi, How do I get an A5 document for 1 project only - greetings card
Fill adjacent cell with number from text answer
SolvedHello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down ...
Create folder in desktop with vba, if exist, ignore
SolvedHello, How to create folder in desktop with vba whenever the excel book is opened, if exist, ignore. Message if create new folder, silent if th...
Dependent (cascading) drop down list in excel
SolvedDear All, Please help me on the below . I have a data validation drop down list with unique values in cell G2. These values are job numbers from C...
Combine sheet in master spreadsheet with auto update
SolvedHello, I have 24 sheets in the same Excel document with identical headers I`d like to combine in the master spreadsheet the way if any data is insert...
Copy data from one excel sheet to another: automatically
SolvedDear all, Anybody can help me please. I have MAIN DATABASE ( sheet 1) of column names : Serial No, Service type, Job No, Date, Customer name, desc...
How do i make all rows the default height in excel?
SolvedHello, How do I make all rows the default height in Excel?
Copy and paste to internet creating whitespace problem
SolvedHello, I created a body of text in Open Office Writer and tried to post it as a question on the website Less Wrong. A moderator rejected it for, as w...
Multiple sheets to one master sheet update
SolvedHello, We are a team of 8 who updates a single excel work sheet, and because of this, there is always information missing or overwritten by others et...
How can i fix hotmail if it keeps freezing or crashing?
SolvedI am using Hotmail and now my Hotmail keeps freezing or crashing. Please suggest reasons and solutions for it.
How can i format multiple presentations automatically?
SolvedHello, I have a lot of presentation and I want to format every ppt to the same font and rate automatically. How can I to do it?
How to calculate positions (1st,2nd,3rd...) in excel
SolvedHello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i...
I can not control the transitions in powerpoint in my file,
SolvedHello, the slides of my PowerPoint moves before the first slide finishes, and sometimes it takes ages to move to another slide. I would like the sli...
"enter to add a blank slide" doesn't work anymore
SolvedHello, I used to be able to add a blank slide in PowerPoint by simply pressing the "Enter" key. For some reason, I found this function did not work a...
Coloring cells in sheet 2 based on data sheet 1 excel vba
SolvedHi! I would like to ask a question about using VBA for colouring a cell in sheet 2 based on a value of a cell in sheet 1. I want to write a code in ...
Udf for attendance register
SolvedHello, I have used your UDF as shown below to report a date whenever an entry is made in a row of my excel sheet. Function LastAttendanceDate(mDate...
Formula to find last date of attendance
SolvedHello, I have an excel sheet that enters the time taken by each student on each day for the whole month. The student names are in the rows and d...
How sum the column value in excel via vba based on criteria?
SolvedHello All, I would like to sum up the column value based on the following criteria (TRUE or FALSE). I have a value in the "E" column and in the "F" c...
Unable to reply to emails
SolvedCan someone advise me how to conquer this sudden difficulty? Emails arrive, I can read them, but when I click "Reply" nothing happens. Why? Than...
Office 365 product key
SolvedHello, Hello. How to activate Office 365 product key. I couldn't do it :)
Apply conditional formatting across several cells
SolvedHello, I want to change the color of a row if there is text in column A of that row. I have the following equation: "=AND(ISTEXT($A$2))" ... and I h...
How to add rows automatically based on cell value in excel?
SolvedHi All, I have a requirement to add the Rows Based On Cell Value In Excel. Below I have attached the snapshot of the requirement details. I have two...
Populate values in textbox based on combobox ,optionbutton
SolvedHello, I have the items in column B in sheet1,2,3 and the prices in columns F,G for sheet1,2 and the prices for columns F for sh...
Running a macro in different cells
SolvedHello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...
Generating invoice number automatic without repetition
SolvedHello, please I need help , I want VBA CODE to Generating invoice number automatic without repetition in my excel any time type in the next cell it...
Macro to automatically update a master sheet from multiple sheets
SolvedHello, I have a file with a master sheet and 6 different individual sheets. Each sheet is considered a project. It includes person's information a...
Working with multiple worksheets in a workbook
SolvedHello, I am completely new to all of this so please bear with me. I am new to forums and how they work so I apologize in advance if this is a repeat ...
How to lock in specific cells in a formula going down rows
SolvedHello, I am having an issue with easily repeating a formula I've made. the formula is =IF(AP2=Sheet2!K3,Sheet2!L3,IF(AP2=Sheet2!K4,Sheet2!L4,IF(...
Hello friends. please help ! countif formula ?
SolvedHello friends. Please help ! I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12"...
Automatically update one sheet from multiple other sheets
SolvedHello, I have a workbook with each office location having its own sheet to keep track of project information all with the same column headings. Co...
Summing values based on matching column across sheets
SolvedHello, Hello, I would match data across sheets based on matching columns B then should add & summing the values to sheet summary under heade...
How to copy data after at a fixed cell
SolvedHello, I have the following data for which it needed to be copied on another sheet after a gap of 7 cells for each entry in Sr No. column. Li...
Autogenerate alphanumeric id numbers in excel?
SolvedHiya! Let me start off by saying I am NOT a tech person so I don't even know if this is possible. I am trying to create an excel sheet where I can ...
Search across all open workbooks for user defined criteria
SolvedHere is my problem - we store info into files that use an index number (changes with each file created) plus 2 criteria to keep track as we produce ma...
Auto-fill items repeatedly for two sheets based on another
SolvedHello, I have two sheets(FIL1,FIL2) should auto fill some items into column A repeatedly . it depends on sheet REP after matching based on colum...
Copying a row based on a integer in a cell
SolvedHello, I am needing help making a macro that will allow me to do a number of things, that may or may not be able to be done with one single macro. (...
How split column into multiple columns for multiples sheets
SolvedHello, I need macro to split column C for sheets REP1,PROC1 into columns C,D,E based on matching column B with column B into sheet RP ...