Excel Forum
-
How to simplify data entry [Closed]
Hi All ok I have a daily sheet that i fill in every day it contains 5 fields I have another worksheet that i then copy the information from the...
-
(Excel Vba) Copy paste of multiple columns [Closed]
Hi All, I am stacked with a simple VBA macro. I have an excel sheet containing a number of columns and i have created a Montecarlo simulation where c...
-
onclick the button view the time in activecell [Closed]
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...
-
Clear the previous Image [Closed]
Hello, I have inserted the image in excel sheet by entering the code in VB. On reload it overwrites the new image on the old image rather than firs...
-
Transferring Data [Closed]
I have monthly payment sheet for each student. I need to take the full roster of payments made to transfer to the individual monthly payment sheet fo...
-
Date drop down on front sheet that will create new dated tabs [Closed]
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 [Solved/Closed]
Hello 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 [Solved/Closed]
Hi 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 ...
-
Unable to download complex tables data on webpage using Query [Closed]
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...
-
Comparing Excel Sheets and copying changed data into a new sheet [Closed]
I'm trying to compare a master excel sheet to updated excel sheets and create a new sheet with the new data. For example: Master Data Sheet has Name...
-
Creating 1 master sheet from data from multiple sheets [Closed]
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...
-
Copy and insert rows n number of times in Excel [Solved/Closed]
I am trying to create a macro under Excel. My data is as follows: Col1 Col2 Col3 Col4 Col5 Col6 Col7 A1 1080 90 M 40 45 50 A2 999 90 M 25 ...
-
Populating a Summary Report [Closed]
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. [Closed]
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 [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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video
- How to Install a VPN
- How to Create a Gmail Account
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen