The discussions
Comparing two columns using partial match logic
Solved/ClosedI need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA. ...
Automaticly change currency format in cell
Hello, I am an estimator in a company that does installation worldwide. We are quoting in many different currencies, and now have to manually make...
Copy & paste issue
word properly copying, however pasting while word into incomplete being. (not entire text). just some letters receiving. some places no, word into pa...
How can i restore images that saved on word file?
ClosedHello! Is there any way via which I can restore some images that I have saved on Word 2013? I have already used some manual methods Like Open and R...
Generate simplified data from raw data
Hello guys, i need help to create some magic from excel. I am a marketer for a F&B, and right now i am in the mid of trying to generate some preci...
Price of ms office word
Hello, What is the price of the microsoft word 2013 after the initial 1-month trial?
Copy rows to rows on another worksheet if " ✔ "
SolvedHi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago and...
Auto populate weekday from a separate date entry
Hello, I am wanting to do two things: 1. In the first column I want to add in the date, in the second column I want it to automatically insert ...
Vba command button
SolvedHi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will...
Vba - button saves textbox data in dif. workbook
Hi Everyone, I need some help creating a code that will allow me to save data input into a TextBox to a different Workbook called "FoundData.xlsm"...
Count total quantity by date into month
SolvedHello, Good Day~ Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order date ...
How to use conditional formatting 30 day notice
I have an excel document that I have set up some conditional formatting and use of icon sets. The only issue I am having, is programming the 30 day a...
Not implemented error message in outlook 2013
Hello, When I try to send an Email to my client suddenly an error message display: “Not Implemented Error Message in Outlook 2013”. There is issue...
Lookup or match
Hi, I have a column in which I have a value I need to look up, then in same column anther value I need to find then return value in column that has an...
Copying specific cells
Hello, I am trying to use a command button to copy information from specific cells in sheet 1 to a excel form I made in sheet 2. The cells are not...
Saving multiple excel files based on a list
SolvedHi, I'm totally new to writing macros in excel but I thought I'd give it a go. I've seen similar threads but I can't find the answer to my problem....
Vba code to copy and paste data multiple times
Hello, is it possible to parse a column and find a value in it, and copy and paste a particular range based on that value in the previous range? t...
Insert blank rows in table range
Am trying to create a macro for below data, the series of data will be in below format. Bahrain United Arab Emirates Oman Qatar Dammam - KSA Riy...
Vba: determine conditions for copy/paste process
Hi guys, first time poster here :) I would need some help defining my copy/paste process. The situation is as follows: - I need to search for s...
Excel text to date conversion
I have column having values like Wed Feb 07 13:39:40 PST 2018; i want to convert to new column as standard date time format. Any clues ?
Copy value from new workbook to existing workbook
Hello, I have new workbook file which is generated every month (every 1st date of the month). The Workbook Name will hava a format like "Historica...
Help me convert a date format in excel
Hello, I need to add the REPLACE, or anything else that convert a date inserted with dots into a date format with slashes, to a long IF formul...
Picture directory
Same kind of scenario where I need to pull in a picture from a server folder into my spreadsheet from an ID number for a person. Sheet 1 has my ra...
Powerpoint support for the lyrics on tablet
SolvedI am a singer and I would like to use my Surface tablet as a support for the lyrics. I can get it to work correctly, but only horizontal. I would lik...
Excel macro program
Dear friends and experts. Greetings for the day !!! Can someone please share with me some ideas on my problem on Excel VB. Thanks in advance for you...
Only ids visible in excel import from access
Hello, I have set up a VBA import to Excel from Access (using code I found during a number of searches online: (https://www.mrexcel.com/board/thre...
Excel vba code for min(sumif() - sumif())
Dear Members of CCM Forum, I thank you all for your great and tireless effort to help the world. I have been using the excel formula: =MIN(SUMIF...
Copy row by row based on pattern matching
i have the following data in sheet 1 A B C D E F day Pe M...
Difference between delete and clear
SolvedCould some one explain both function ("Delete" and "Clear" in Excel) ?
Vba macro - scan worksheet for specific value
Hello, Looking to create a VBA macro on Excel which scans a worksheet on the document for a specific value(s) and then tally up the results and ex...
Office 2000 upgrade
Hello, I have an old issue of Office ie 2000 which I purchased a few years back, do I now have to pay for the updated versions? System Configur...
If a column has a value add to another column?
SolvedHeya, i hope someone can help me with this. I currently have a very large formula sheet made up so i can input a value and add it too my total along w...
Create rows based on input in columns
Hello, I have a below table: And I would like to create the following automatically: Is there any easy way to create it? Thanks a lo...
Copy and paste a record in same table - access/vba
SolvedHello, This might be more complex than the title suggests... I have a task tracker that records; tasks, date recorded, frequency (d,ww,m,q,yyyy...
Excel if statement
Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has "Yes" then I want the todays date to sho...
How to change format from mm/dd/year to dd-mmm-yea
hello Seniors, please solve my query: I need to change format of data in my excel sheet, for instance data is in the format of mm/dd/year while I ...
Conditional formatting
Hello, I want to change the font color for lines that have been updated. If a new position or new step is entered, the font colour of the entire ro...
Separating records by relocating cells
Hello All, I need to automate the following process: I've an excel worksheet that is (columns x rows) 19 x 260 size, arranged as follows; I...
Adding days to dates
Hello, I was hoping someone could help with this, I am creating a spreadsheet and am having problems with the following: Column D shows Date E...
Create new workbooks using a template workbook
Hello, Any chance someone would know how to create a macro that would take an existing excel workbook template with data on Sheet1 and have the mac...
Modifying case function in vba code
Hi hoping someone out there can help. I'm reasonably new to VBA code and was hoping to modify a CASE reference code to modify cell colour based on ano...
Is there a good "contact" manager?
Hey all, I hope everyone is doing great today! I have a need for a contact manager, that will run on both a PC, and Iphones. So, a secretary can e...
Convert from figure to words
Hello, Sir, How to convert in to words from figure System Configuration: Windows / Chrome 68.0.3440.106
Copy 5 rows at a time from the master workbook
Hello, Is it possible to copy 5 rows of data from the master workbook at a time? I have approximately 10 sub workbooks where I would like each...
Macro to copy / paste cell text down various rows
SolvedHello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within their...
Referencing a field in a subform (ms access)
Hello, In MS Access, I have embedded a subform query into a task closure form that is linked to a task table. I was able to set the form so that ...
Macro submit data drop to next row upon submission
SolvedHello, I am currently working on an Excel workbook that allows for a user to input specific information pertaining to WIP product, click the comma...
How to auto transfer data from sheet a to sheet b
Hello, pls teach me how to autotransfer data from "sheet 1" to other sheet "IAS2901" "IAS2902"... follow by the code in "sheet 1". this sheet1 da...
Recalculation
SolvedHi friends I need your help to do an operation. I have a worksheet that I calculate with f9 key.L18 cell is "OK" or "CHANGE" depending on 20 cells. ...
Open multiple workbook and populate them
Hi, I've been working and looking for a solution/code for a while but couldn't find anything that would fully work. 1. 'Name details.xltx' is t...
