Forum
Office Software
- Popular discussions
-
if cell = date return yes or no. [Solved/Closed]
Hello, I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes,...
-
to calculate positions(1st,2nd,3rd...so on) [Closed]
Hello, 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...
-
Removing " false" value in "IF&quo [Solved/Closed]
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an...
-
if date in cell is greater than date in cell [Solved/Closed]
Hello, I am a beginner with formulas in Excel. I am working with dates formatted dd/mm/yyyy. I need a formula that will return a value of yes...
-
Convert number to spelling [Solved/Closed]
Hello, I Can change the Number into Spell but the problem is it does not convert in Indian Rupees. Present Situation =SpellNumber(58.20) =...
- More »
-
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...
-
Saving multiple excel files based on a list [Solved]
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...
-
Count Qty by mth to the order date [Closed]
Hello, I need a formula that helps me calculate the quantity by month to the order date and also by venue and type. I have tried to use a...
-
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...
-
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 -...
-
Copy defined columns data from several Worksheets [Closed]
Hi, I need a VBA code to copy the predefined columns (5-6 Columns) data in new excel and also need Refresh code to erase all data it has...
-
Help with inventory tracking [Closed]
Hello, We're using excel to monitor our inventory. We all have pretty basic excel knowledge. We'd like to be able to track our stock levels...
-
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...
-
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...
-
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...
-
Scroll bar for single cell [Closed]
Is it possible to add a scroll bar on a single cell which contains too much text ?
-
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...
-
Powerpoint support for the lyrics on tablet [Solved]
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...
-
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...
-
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:...
-
Need macro to copy paste @ variable [Closed]
Hello, Let us say i have a standard distribution of hours in a row as per below example. A1 A2 A3 A4 A5 A6 Jan Feb Mar ...
-
Copy rows to rows on another worksheet if " ✔ " [Solved]
Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago...
-
Macro Auto Run at specific time [Closed]
Hi, I am new to excel macros and I have an excel with auto mailer macro. This excel will be updated regulary by team members. Now I want to...
-
Universally change font color - NitroPro
I received a PDF in which the font was all grey, making it difficult to read. I'd like to convert it all to black, but seem to be able to only do...
-
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...
-
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:...
-
COPY ROW BY ROW based on pattern matching
i have the following data in sheet 1 A B C D E ...
-
Difference between Delete and Clear [Solved]
Could 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...
-
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...
-
If a Column has a Value add to another column? [Solved]
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...
-
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...
-
Copy and paste a record in same table - Access/VBA [Solved]
Hello, This might be more complex than the title suggests... I have a task tracker that records; tasks, date recorded, frequency...
-
If value is >= 10 then send Outlook mail
Hello, I m now learning vba now but cant solve my issue at work What I want to do is ...in one of my excel worksheet , in column G, for any...
-
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...
-
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...
-
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...
-
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...
-
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...
-
join the formula [Closed]
=IF(ISBLANK(C17),"",IF($L$14="INTER STATE SALE",(M33)))&IF($L$14="STATE SALE",(I33+K33))
-
Adding days to a date based on drop down menu [Solved/Closed]
Column D shows Date Enrolled, Column E shows Experience (options are more than 1 year or Less than 1 year) I would like column F to add 35 days if...
-
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...
-
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...
-
I want data from 12 sheets to be transferred to a [Closed]
I want to great a master sheet out of 12 sheets. I am having a hard time doing this. Can I get your assistance? I ran various Macros already and...
-
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...
-
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...
-
MACRO to copy / paste cell text down various rows [Solved]
Hello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within...
-
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...
-
MACRO Submit data drop to next row upon submission [Solved]
Hello, I am currently working on an Excel workbook that allows for a user to input specific information pertaining to WIP product, click the...
-
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...
-
I got a copy protect software but it has failed to [Closed]
Hello, i bought a copy protect software but it has failed to work, it just stops in the middle
-
Recalculation [Solved]
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...
-
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'...