Excel Forum
-
Date format not valid [Closed]
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 [Closed]
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 [Closed]
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" (...
-
Automatic when excel open reminder mail go through outlook [Closed]
Hello, I wan to know how to send reminder mail from excel when it open and when before due dates of 3, 7, 30 days before multiple reminders I wan...
-
Shortcut to edit a cell without using F2 key [Solved/Closed]
Hello, 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...
-
Selecting a block of cells depending on the values of two others [Closed]
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...
-
Conditional formatting based on column of values [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
I 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 [Closed]
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 [Solved/Closed]
Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...
-
Need to delete columns based on Column header [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 ...
-
Caculating the number of months between a set of dates [Closed]
Hi, I am trying to calculate the number of months between two dates that relates to a specific time frame (financial year). Is anyone able to su...
-
Auto Generate Dates [Closed]
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 [Closed]
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...
-
Auto generation of code [Solved/Closed]
Hello, 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 ?? [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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...
-
How to use VBA Macros in excel 2016 [Closed]
Hi, Need a bit help for now. I am going to make transmittal that has two sheets which includes input(data) and output(transmittal). This will be my tr...
-
Excel - A macro to create new workbook and copy data [Solved/Closed]
In 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...
-
How to populate sub sheets based on criteria from a master [Closed]
Hello, I'm working on a master file with sub sheets. I'd like to auto populate data from rows A-S to sub sheets (Dave, Jamal, Addi), based on data ...
-
Excel - macro to create multiple sheets [Solved/Closed]
Hello, 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 ...
-
Macro to move data from one workbook to other workbook [Closed]
Hi, I am working on two different workbooks, one of them is a scorecard and the other is the data entry workbook, I am trying to copy a lot of cell...
-
Copy cells to new sheet to create order form [Closed]
I am trying to write code that will allow me to place an "X" in column A. In response I would like the cells in that line (B:E) to be copied into the...
-
Comparing columns and returning value [Solved/Closed]
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...
-
Compare two sheets in Excel [Closed]
Hello, First, thank you for taking the time to help me understand how to execute this comparison. I have an excel file with two sheets. I need ...
-
Transfer multiple excel data from cells and moving to another wo [Closed]
Hello, I would kindly appreciate your help in getting an answer to my question, which is, I have used "Find & Select," specifically Find & Replace...
-
Using Find & Select [Closed]
Hello, I have used "Find & Select," specifically Find & Replace dialogue box to find specific values/data and then REMOVE, CUT, and Move to anothe...
-
Data in Hot Key [Closed]
I want to put an email address in a hot key so I don't need to type it ever time.
-
how do i calculate VAT inclusive [Closed]
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...
-
macro automatic numbering of invoices combined with letters [Closed]
I want to know how to perform a macro for automatic invoice number combined with letters at the beginning for example XZY0001
-
Excel Logic [Closed]
Hello, when i input R in cell, it shows a tex "ok" Or "Not Ok" in another cell
-
Split single excel worksheet into multiple worksheets [Closed]
While I see many VB solutions 'almost' there, I don't see a solution for me. Challenge is I have client data where each set of data has 'Patient Code...
-
Conditional Formatting [Closed]
Hello everyone, I'm trying to compare a table from one sheet to one on another sheet, and was wondering if its possible to copy the conditional forma...
-
Change of date [Closed]
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 ...? [Solved/Closed]
Hello 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...
-
Use of macro for copy,Edit and Then Paste. [Closed]
Dear All, I have a set of data covering 9 columns and 62 rows. (A1:I62). Now I want whole data of column 6 (F) to be changed to another data and so...
-
Comparing two spreadsheets using a third for comparison [Closed]
Hi, I have two spreadsheets with same columns from different sources. I'm trying to use a 3rd spreadsheet to compare the two & show me any diffs. I...
-
arrow keys are not working [Closed]
Hello, Arrow keys are not working in my laptop. System Configuration: Windows / Chrome 57.0.2987.133
-
Comparison [Closed]
Hello, I want to create an excel sheet for data entery. There will be a two cases. Case-1:- The value of one cell is equal to value of another ...
-
Autopopulating multiple sheets from one main sheet [Closed]
Hello, I'm making an quote workbook for an organization and I've run into a problem. On the first sheet "Main sheet" I input all of the transa...
-
Highlight date range if cell containing date falls within that range [Closed]
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....
Subscribe To Our Newsletter!
