Forum
Office Software
-
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 -...
-
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...
-
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...
-
Excel text to date conversion [Closed]
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/Closed]
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 [Closed]
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 [Closed]
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 ...
-
Universally change font color - NitroPro [Closed]
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...
-
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...
-
Excel VBA Code for Min(SumIf() - SumIf()) [Closed]
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 [Closed]
i have the following data in sheet 1 A B C D E ...
-
Difference between delete and clear [Solved/Closed]
Could some one explain both function ("Delete" and "Clear" in Excel) ?
-
VBA Macro - Scan worksheet for specific value [Closed]
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 [Closed]
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/Closed]
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 [Closed]
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/Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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...
-
Is there a good "Contact" manager? [Closed]
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...
-
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...
-
Convert From figure to words [Closed]
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 [Closed]
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/Closed]
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) [Closed]
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/Closed]
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 [Closed]
Hello, pls teach me how to autotransfer data from "sheet 1" to other sheet "IAS2901" "IAS2902"... follow by the code in "sheet 1". this...
-
Recalculation [Solved/Closed]
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 [Closed]
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'...
-
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
-
Content for an existing, either updated access [Closed]
Good afternoon, please let me how to log in to an account within a credentials, e-mails credentials, existing content to contray a Office...
-
ms offce 2010 pruduct key [Closed]
Hello, sir most Request meb sir this ms office 2010 ccm side to dwonlode me and prodect key not valid System Configuration: Windows /...
-
VBA Excel help Colour a cell that contains 0 [Closed]
Hi, I have a table that displays data from another tab using VLOOKUP, although i have some cells that contain a 0 I have tried using...
-
Create workbooks from a list [Closed]
Hi I'm totally unfamiliar with Marco's, so I hope someone can help. I need to create 200 excel sheets from a template and save them with the...
-
Comparing 2 worksheets in Excel [Closed]
Hello, I wanted to compare 2 worksheet. If there is a different it return the as below Sheet 1: Apple vs Sheet2:Orange and if no...
-
How to find the Microsoft product key? [Closed]
Hello, i download microsoft but how can i enter product key System Configuration: Windows / Chrome 68.0.3440.84
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD