The discussions
Onclick the button view the time in activecell
Hi, I am using this code it's run successfully but each time click the button then overall change the cells. I want each cell view the current time...
Date drop down on front sheet that will create new dated tabs
Hello, I am trying to create a workbook for recording daily pressure readings from different systems and I am trying to create a front page with a...
Excel vba - find and expand matching cell entries
SolvedHello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...
How to populate information on multiple sheets at once
SolvedHi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...
Outlook 2007 is not sending mails
Solved/ClosedHello, Have a nice day. I migrate my data from one PC to another. The old one was having Windows XP operating system along with Outlook 2003 w...
Unable to download complex tables data on webpage using query
Hello, I am trying to figure out a way to download the data from this webpage, which has 4 collapsible sections but no luck whatsoever yet. htt...
Cant get access on outlook
Hello, dear please i have yahoo account and i want to open on outlook but cant get access please guide me System Configuration: Windows / Firefox ...
Creating 1 master sheet from data from multiple sheets
Hello, So I am at a complete loss on how to solve my problem. I'm brand new to excel and any help would be much appreciated. What I'm wanting t...
Populating a summary report
I've been tasked with taking a large worksheet (>20K rows and 25 columns) and populating a summary report in a (pre-labeled) different worksheet. The...
Autopop info on sheet based on criteria from master sheet.
Hi All, I am creating a Master spreadsheet that has information across rows. I want this information to auto-populate on a different spreadsheet dep...
Date format not valid
Hello, Sir i would like you to help me on the following problem, i am filling an application form and i have done everything but on the date side ...
Splitting data from worksheet to workbooks based on column
Hello, The code gives prompts me to enter the column on which the split needs to be done, but soon after that thrown an error:Run-time error '1--4...
If/and function
i need to update a spreadsheet on the progress of documents being approved. i want to create a function that states if the document is "approved" (...
Shortcut to edit a cell without using f2 key
SolvedHello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...
Restoring pst file from hard drive.
ClosedHello, Next problem, a hard disk to copy the file .PST mail that houses that work in one place. At home and at work worth outlook 2007. I tried to...
Selecting a block of cells depending on the values of two others
Hi all I'm pretty new to macros and I have been unable to find the answer to this question anywhere. I'm trying to write a macro that will selec...
Data in a hot key
SolvedHello, I want to put an email address in a hot key so I don't need to type it ever time I need to insert it. Thanks for your help in advance.
Conditional formatting based on column of values
Hello, I would like to do conditional formatting column B if its part of text matches with values in any cell of column C. Could you please help m...
Macro to create worksheets and copy data from a summary page
I have a workbook called Sales Commission and sheet 1 is my summary page. I want to write a macro that will look at the summary page and from column ...
Conditional format if hyperlink
SolvedHello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...
Convert a sentence in a cell with the american date
Hello, I am trying to convert a sentence in a cell with the American date last to the sentence with Canadian date last. ex. CASH OVER/SHORT 04/01...
Copy and paste values automatically to empty cells below
Hi - for background, I created a "slot Machine" in excel that combines three random number generators and generates either a -$1 or +$10 if you don't ...
Vba help needed
Hello, I have written code to prompt the user to state how many new sheets they want to add. But I need for the data on the "Main" sheet to always ...
Compare the words in 2 columns in excel
SolvedI gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...
Drop down menu, copy/transfer 2 new sheets only if cell has data
Hello, I am trying to create a sheet that references items if they are selected from another sheet from a drop down menu. IF they are selected then...
Excel forum within a range
SolvedGood day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...
Convert wordpad document back to pdf
SolvedHello, i as sent a file and wheni went to open it it said open with word or internet i picked word and now its not what i wanted to have done beca...
Need to delete columns based on column header
SolvedHello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...
Compare 2 columns on different sheets and move data when match
Hello, I need to match 2 columns of data from 2 different worksheets and when they match, I need to move data from another column from one workshe...
Copying an entire list of formulas into another work sheet
Hello, I have a list of sumif statements that I would like to copy from one excelsheet to another. Can this be done all at once, without changing ...
Auto generate dates
Hi All, I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only we...
Summery sheets
Dear All, I am maintaining a File in Excel for Employee's Vacation and every year has a different file. In this file I am adding a new Sheet by the...
Do i have open office available
Do I have open office available on my computer?
Auto generation of code
Solved/ClosedHello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...
What is the numbe shoud be instead of ??
what is the Numbe shoud be instead of ?? My Values fixed No Results 70064 ?? -11 1721118038 ?? ...
Need macro to copy certain data from a form on one tab to a log
Hello, Trying to copy data from a form on one tab to a log/data list on another tab and advance to the next line on the log for the next user ...
Vba coding to copy data from one worksheet to another worksheet
Hello, I would like to know how to use vba coding to automatically copy data from one worksheet to another worksheet based on a specific criteria an...
Filter between 2 dates
Hello, please i want to filter data between 2 dates (start date and end date) with textbox and button command, i am new to programming in vba; plea...
Pdf document "converted" to word is not editable
ClosedI downloaded your PDF to Word conversion software. I then did a conversion so that I could do some editing of my document that I had previously create...
Excel - a macro to create new workbook and copy data
Solved/ClosedIn the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...
Converting software
What is the best software download that will convert both excel and word PDF files into usable excel and word documents for Windows 7?
Word doc automatically changes to pdf
Hello, How do I save a Word Doc as a Word Doc? When I go to the doc a second time ,it automatically changes it to PDF with all kinds of changes. So ...
Excel - macro to create multiple sheets
SolvedHello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...
Comparing columns and returning value
Solved/ClosedHello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...
How do i calculate vat inclusive
Hello, how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18% System Configur...
How can i get my cvs out of my old office
Hello, how can I get my cvs out of my old office System Configuration: Windows / Edge 14.14393
Change of date
Hello, I Want to change date format mm/dd/yyyy to dd-mm-yyyy in MS Excel 2003 Please solve my problem urgently System Configuration: Windows ...
Import .pdf ...?
SolvedHello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...
Highlight date range if cell containing date falls within that range
Good day! I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell....
Freezing column and row
Hello, how do you freeze first column and top row in excel?
