The discussions

Comparing two columns using partial match logic


I 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. ...

Last reply on 22 Oct 2018 by

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...

3 replies Last reply on 18 Oct 2018 by

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...

2 replies Last reply on 17 Oct 2018 by

How can i restore images that saved on word file?


Hello! 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...

Last reply on 17 Oct 2018 by

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...

1 reply Last reply on 16 Oct 2018 by

Price of ms office word

Hello, What is the price of the microsoft word 2013 after the initial 1-month trial?

1 reply Last reply on 12 Oct 2018 by

Copy rows to rows on another worksheet if " ✔ "


Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago and...

19 replies Last reply on 12 Oct 2018 by

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 ...

1 reply Last reply on 8 Oct 2018 by

Vba command button


Hi 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...

10 replies Last reply on 2 Oct 2018 by

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"...

1 reply Last reply on 1 Oct 2018 by

Count total quantity by date into month


Hello, 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 ...

3 replies Last reply on 28 Sep 2018 by

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...

1 reply Last reply on 26 Sep 2018 by

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...

3 replies Last reply on 24 Sep 2018 by

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...

3 replies Last reply on 21 Sep 2018 by

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...

1 reply Last reply on 20 Sep 2018 by

Saving multiple excel files based on a list


Hi, 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....

4 replies Last reply on 20 Sep 2018 by

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...

1 reply Last reply on 19 Sep 2018 by

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...

3 replies Last reply on 19 Sep 2018 by

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...

2 replies Last reply on 17 Sep 2018 by

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 ?

1 reply Last reply on 15 Sep 2018 by

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...

1 reply Last reply on 14 Sep 2018 by

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...

1 reply Last reply on 14 Sep 2018 by

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...

1 reply Last reply on 11 Sep 2018 by

Powerpoint support for the lyrics on tablet


I 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...

6 replies Last reply on 10 Sep 2018 by

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...

3 replies Last reply on 10 Sep 2018 by

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: (

9 replies Last reply on 7 Sep 2018 by

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...

1 reply Last reply on 4 Sep 2018 by

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...

1 reply Last reply on 4 Sep 2018 by

Difference between delete and clear


Could some one explain both function ("Delete" and "Clear" in Excel) ?

1 reply Last reply on 3 Sep 2018 by

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...

1 reply Last reply on 3 Sep 2018 by

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...

1 reply Last reply on 31 Aug 2018 by

If a column has a value add to another column?


Heya, 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...

4 replies Last reply on 30 Aug 2018 by
Anonymous User

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...

2 replies Last reply on 29 Aug 2018 by

Copy and paste a record in same table - access/vba


Hello, 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...

9 replies Last reply on 29 Aug 2018 by

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...

1 reply Last reply on 28 Aug 2018 by

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 ...

1 reply Last reply on 28 Aug 2018 by

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...

2 replies Last reply on 28 Aug 2018 by

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...

1 reply Last reply on 28 Aug 2018 by

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...

1 reply Last reply on 28 Aug 2018 by

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...

1 reply Last reply on 23 Aug 2018 by

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...

8 replies Last reply on 23 Aug 2018 by

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...

5 replies Last reply on 22 Aug 2018 by

Convert from figure to words

Hello, Sir, How to convert in to words from figure System Configuration: Windows / Chrome 68.0.3440.106

1 reply Last reply on 22 Aug 2018 by

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...

7 replies Last reply on 17 Aug 2018 by

Macro to copy / paste cell text down various rows


Hello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within their...

6 replies Last reply on 14 Aug 2018 by

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 ...

4 replies Last reply on 14 Aug 2018 by

Macro submit data drop to next row upon submission


Hello, I am currently working on an Excel workbook that allows for a user to input specific information pertaining to WIP product, click the comma...

11 replies Last reply on 11 Aug 2018 by

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...

5 replies Last reply on 9 Aug 2018 by



Hi 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. ...

4 replies Last reply on 9 Aug 2018 by

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...

3 replies Last reply on 9 Aug 2018 by
Results 601 - 650 out of a total of 12,267