The discussions
Create a macro to open workbooks
Hello, Please help me to create a macro which will help me to open different excel workbooks and copy particular data/ figures from excel sheets t...
Moving data to multiple sheets
I have a spreadsheet that I want to enter data into a main location and then have it go to specific sheets based on state and date entered. My data i...
How to place and x in cell f7
Hello, I am in excel, I want to be able to place and X in cell F7 and have the time automatically be placed in cell G7. can someon please help me. T...
Convert number to spelling
Solved/ClosedHello, I Can change the Number into Spell but the problem is it does not convert in Indian Rupees. Present Situation =SpellNumber(58.20) = Fifty ...
Applying conditional formatting rule to other rows
I have a row with multiple cells. two cells have drop down lists. If the first cell has value "A" from the dropdownlist, and cell 2 has value "B" from...
How to transform .ost in .pst ?
ClosedWe need an easy way to transform . OST in . PST ? What is the easiest way to do this? I just need to work with e-mail now, and I don't have such an op...
Transfer data from 1 sheet to another with cond.
SolvedHi, I am having trouble working out how I would code this using VBA: In Sheet 1 I have 2 rows. The first row is the title and then the second ro...
Macro to manipulate lines of text
SolvedI have data that is arranged as this in four columns x emailx nameofx 123 x emailx nameofx 4456 x emailx nameofx 67 y emaily nameofy 12 z email...
Macro for inserting pictures from folder to excel
Hi guys I am new here and would appreciate any help for the following issue: I have an excel sheet with more than 100 product codes (e.g. 00501-016...
Find and replace from a dropdown
Solvedhi Guys, second and hopefully last question for now. Is there a way to the following: I have a dropdown list with names of tabs of the excel file...
Dob conversion in excel
Hello, how to do work DOB conversion in excel sheet System Configuration: Windows / Chrome 64.0.3282.186
How to easily cummulate data
SolvedHi there, I was wondering if you guys know how to do this: got 13 weeks, each week has a figure underneath it. Let's say week 1 has 1 under it, wee...
Vba code to create pivot table
Dear all, Attached and show below the xls sheet. I need help from the forum, once I click the button, a pivot table to be generated in a new s...
Change color of cell comparing contents to 2 cells
Hello, Hope someone in this community can help me write a vba code to for example: Cells B3 and C3 have a value When I input values into cells r...
Pull data from sheet 1 to sheet 2
I would appreciate any help for my case. So in sheet 1 called WIP, consist of item descriptions (C1) and quantity to be build (D1). The item descripti...
Copy paste in loop in loop
Hi Trowa, I am new to Macro - but i have similar request to copy paste in 2 loops 1. copy a number times Sheet 1 Column 1 data ( say having 3 val...
Automatic payroll computation
Hi everyone. Im just new to my job and one of the task assigned to me is to compute payroll for our employees. im not that knowledgable with excel, m...
Counter/animation
Hello, I have quite a unique question regarding powerpoint. I'm wondering if it can be done. I wish to make a marking scheme on powerpoint say for ...
Automatically change the cell from general to date
Hello, System Configuration: Windows / Chrome 64.0.3282.186 Somehow i am facing an issue again and again in my office 365 excel, when i sa...
Pdf and word files not opening
Suddenly one day my PDF and Word files stopped opening and now I get an error that "windows cant find the file (address), make sure you typed the name...
Label making
Is there a label and envelop making program using Avery on this program.
Copy text from one work sheet to another
ClosedHello, Could some one help explain how I can simply copy text from a cell in a different work sheet. I'm trying to make a report using the months of t...
How do you change cell colour based on date
Hello, How do you change cell colour automatically based on date. I am trying to set my training spreadsheet so I can clearly see when staff membe...
Repetitive formulae
Hello, how do I construct multiple pages with the same set of formulas? System Configuration: Windows / Internet Explorer 11.0
How to copy information from sheet 2 into sheet1
I have a spread sheet with two sheets. The first contains names and i need to copy information from sheet 2 into sheet1. in Sheet 1 F66 =Sheet2 A2 ...
Ms-office activation code
Have just downloaded MS-Office from the site What is the activation code?
How to cell in sheet 1 into another calendar sheet
Hello, Elson here. Would like to ask. How to transfer a date + remark from sheet A, into a calendar sheet B. For example. Sheet A Cell 1: date (...
Salary difference from two years based in employee
Hello, Hi sir/ madam I have two sheets and in one sheet consists of 2007 year employees details ( I'd and salary) and second sheet also consists ...
Assistance request - if statement and adding time
Hello Friends, I would be extremely greatfull if someone would have the time to assist me with a formula in Excel. I also know this is a voluntary...
Insert multiple copied rows at fixed intervals
Helo Would you please help me by giving Solution for my Question how I can insert multiple copied rows n time at fixed interval using excel macros ...
Find a value in a matrix array
Hello, Is there any formula to find a value in a matrix array A program in gw basic i want to change it into excel. Suppose A B ...
School report card with data of all classes
dear sir/madam i am looking for excel work for school report card, one sheet where i want to put data as where data will be entry(sheet-1) class...
Moving rows overflow from cols a&b to c&d help
Hello, I'm new to this macro business but I was able to create a sheet that functions 95% of how I want it to. My only problem now is that my shee...
Insert the number 001 in column a if b a00-a10
Hello, In column B the data range from A00-Z99 and I want to insert the number 001 in column A if B A00-A10 and 002 if columnB A11-A20 which f...
Trying to record data next to date cells for today
Basically what I am looking to do is to record the minutes and seconds of each call taken manually and then where the dates are, I want it to record t...
Transfer data automatically in one sheet
Dear all, I am facing a problem to transfer the data from different sheets to one sheet with the help of Macro. I have attached the excel file,...
Estimate, print area if quantity is over 0
Hello, I am trying to make estimate software for a remodeling company. I just want the description to be printed or copies to clip board if quanit...
How to i download adobe flash reader?
Hello, how i download adobe flash reader System Configuration: Windows / Chrome 64.0.3282.186
How to add 200 working days to a given date.
SolvedHello, Please I want to know how I can add 200 working days to a specific date to get a new date
Write macro to search and copy to new workbook
I receive sales report each month and I filter and subtotal these to show the total units purchased by each store over the month. I want to create a ...
Auto populate data between excel sheets
SolvedHave project management data that should be automated to populate from two Excel sheets to the desired Excel sheet. I was thinking that it could be A...
Powerpoint to video converter
Dear Sir i m making powerpoint slides by inserting the video in it and want to convert into video. Have u any software
Help creating a rubric
Hello folks, I have used some VBA in excel before, but I am wondering how to go about programming a macro to be used in a rubric so that I can doub...
Cannot change the date format in excel 2007
Solved/ClosedHello, I have tried everything mentioned in this forum and they still do not work. I have a sheet with the date appearing dd/mm/yyyy, I have ...
Cell background colour
Hello, Is it possible for a cell to change colour as a warning that the date in the cell is nearing going out of date. System Configuration...
Lost important documents with calculations
I often work on different calculations in Office 2016. But after a serious system crash I was unable to open some of the files that I need for the nex...
Macro to delete rows if cell contains string
Hello, I need help creating an Excel macro. I have a large sheet that has cells with large amounts of text (error messages). I would like to delet...
Program
ClosedHello everyone, I need help, who has good skills in excel programming ? I need to create a useful program in excel for my course paper
If formula in excel
I have this in excel as a VBA , however it wont work unless the field is manually keyed , ideally I want a drop box with Yes , No , Unsure . can this ...
