Excel Forum
-
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....
-
freezing column and row [Closed]
Hello, how do you freeze first column and top row in excel?
-
how to transfer file [Closed]
Good morning Everyone, I have a Purchase Request list and l wanted to copy a data to one worksheet to another automatically once it's approved in ...
-
Change a cell content according with the color of another cell [Closed]
Hello, I´m using Excel and need to change the VALUE of a cell (need to appear "-") if the COLOR of another cell is PURPLE. After digging around wit...
-
Pasting and deleting macro [Closed]
Hello, I need to create a macro that paste macro buttons from one spread sheet to another spread sheet, but when I try to do this and assign the mac...
-
Nestle fomula nightmare!! [Closed]
Sorry - fixing mini typo Hello - any help!! Going bald ripping hair out trying to resolve! I want to return a value "Q1" if a date falls between...
-
Need help on Excel macro [Closed]
I need help to create a macro which helps me to get data from 'Sheet1' and paste that number of counts in 'Sheet2' for example, i have a table in s...
-
Highlight date range if date occurs within that range [Closed]
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. How do I accom...
-
EDATE in excel help [Closed]
Hello... I have a training for log for a large number of staff for various different courses which have all been completed at various different dates ...
-
Excel for Mac date formatting [Closed]
Hello, I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in whi...
-
Format excel data [Closed]
Hello, i need to modify the data in my excel. Right now the data looks something like this: case A start 51 stop 55 ...
-
Copy rows from one tab to another - if specific criteria in col [Closed]
Hello, In a file, I am trying to copy data from one row of a worksheet if specific criteria are met in one column to another worksheet. Ex: ...
-
EDATE [Closed]
I have a training for log for a large number of staff for various different courses which have all been completed at various different dates and I wan...
-
Running a macro in different cells [Solved/Closed]
Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...
-
auto populate data from one sheet to a second [Closed]
I am trying to have the information entered in the first 2 columns on sheet 1 transfer to sheet 2 in the same location automatically. There are appro...
-
Formula [Solved/Closed]
I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
-
Transferring Data from Multiple sheets to one [Closed]
Hello, Disclaimer: I am new to macros and VBA, so reading the code is difficult, but I am making it a priority to learn. My problem. I track co...
-
Use Excel Template as a Sign In Form [Closed]
Hello, I wanted to use an excel file as a sign in sheet. I need user to read the agreement that is presented on screen in an excel file. After read...
-
HELP FOR TIME REMINDER IN EXCEL [Closed]
Hello, I entered some date in excel and I need to be reminded one day before that expected date !! How do I code it so that I will get a reminder ...
-
Graduate number in a cell [Closed]
Hello, I have this database on Excel that I want to create. One of the columns will have the date of birth (DOB) and another column will have the...
-
Conditonal Formating [Closed]
I have a training spread sheet that is used to track the due date of the training for our field personnel. We also use it to determine if the trainin...
-
software for finanicial [Closed]
how can i get a software for account system tally ,quickbook
-
countif coloring of cells that were used. [Closed]
Hello, I would like to color cells (or a row) that were used for "countif" values. for example, at my work, i have to indicate private calls f...
-
copying data from multiple workbooks [Closed]
Dear all, Greetings of the day..!!! I m looking for a macro for the below requirement. There are multiple workbooks in a Folder, all workbook...
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- How to Get More Followers on Instagram
- How to Upload High Quality Photos to Instagram
- How to Recover a Disabled Facebook Account
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account