Excel Forum
-
add the value of one cell only if another cell has a certain # [Closed]
Hi everyone. I'm trying to make a spreadsheet to categorize business expenses into IRS categories. For example Column C has the cost for each ex...
-
Totaling amount from 1st tab depending on another column states [Closed]
Hello, I have 2 worksheet, 1st worksheet shows 2 columns A1 ($0.00) and A2 (names). 2nd worksheet I want it to calculate if the name column A2 sta...
-
How to populate data to another tab [Closed]
Hey there, If anyone could please spare a moment to help me with this, it would be much appreciated, more than you will know ! What I want to d...
-
comparing 2 columns from 2 different spreadsheets [Solved/Closed]
Hello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer numbers Spreadsheet 2...
-
Copy 10 sheets (along with data) into new 10 sheet in Same excel [Closed]
Hello, I have an Excel which contains 10 Sheets with data.., Once a Go button is Clicked it new 10 sheets should be opened in same Workbook along ...
-
set a conditional year end date outcomes [Closed]
Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31/201...
-
Macro code [Closed]
Hi there. So I have a question. I want to create a macro that makes uses the list of name in cells B6:B60, E6:E60, B66:B119, and F6:F74 to make a tab ...
-
compare two columns input value from another [Solved/Closed]
Hello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we will ca...
-
Macros - How to populate data to another tab [Closed]
Hey there, What I want to do is this: I have data on sheet 1, which is separated into columns, Headings are: Property Code, Customer, Document, ...
-
If Then for date outcomes [Closed]
Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31...
-
Macro for automatic paste in sequence [Closed]
Hello, I have a calculation sheet for experiment results with time. Everytime I am manually copy paste results from result raw to another raw i...
-
Automate copying data from one sheet to another [Closed]
Hello, Could you help me with the below issue please? I have 2 different sheets in 2 different locations (say one is the Master sheet). I need ...
-
Highlight cell if another cell contains any text [Solved/Closed]
Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...
-
Senior accountant A/R [Closed]
Hello, i cannot transfer data more than 54 column to another sheet(can not write more than 54 cell same row in the code) Configuration: Windows...
-
So close! Script creates worksheet and populates BUT [Closed]
Over the last 10 hours I have researched and pondered and really enjoyed the process of building up this program, but my shift is almost over and I wo...
-
Macro that Creates New Worksheets based on Data from a List [Closed]
I've been researching and attempting to create a macro for the past few hours. I have a workbook with 2 worksheets. 1st worksheet contains a table tha...
-
Copy and paste macro button based on a condition [Closed]
Hello, I am very new using VBA. I have daily time I am entering for employees in a worksheet. It is summarized in a table at the bottom of the wor...
-
Excel help please [Closed]
Ok here's what I want to accomplish. I want to be able to type the name of a medication: and the formulations automatically appear in the rows foll...
-
auto row copy to another worksheet [Closed]
I'm new to excel and need to set up a simple double entry bookkeeping system in excel. I need to know what formula to put into a cell to accomplish t...
-
Assign numerical value to cell based on text in another cell [Closed]
Hello, I'm trying to solve an issue... Column A cells have a drop down which has 4 text options to choose from: Tier 1 Tier 2 Tier 3 Tier 4 ...
-
Copy and paste macro button based on a condition [Closed]
I have daily time I am entering for employees in a worksheet. It is summarized in a table at the bottom of the worksheet. When today's data is entered...
-
Tracking changes on a work book [Closed]
Hello, just to inform, i don't know how to create a macro or visual basic program. I have an excel sheet that contains 500 line items. each ite...
-
Runtime Error 6 - Overflow error with a variant type variable [Closed]
Dear All, Kindly help me with the below coding where i get Runtime Error 6 - Overflow error when executed. Private Sub Workbook_Open() Dim ws A...
-
Word Search [Closed]
Hello, I need some help. I basically do not have the knowledge about Macros or VB in Excel I just need some help on this hope you can understand m...
-
Find words within a cell, use a list to identify and place value [Closed]
Hi everybody I would be really appreciative of any suggestion you might have. I have used a solution provided previously which was terrific however ...
-
Excel macro to create workbooks and synchronize data (and more) [Closed]
Hi there, A little more than a year ago I made a commitment to go in-depth with Excel. Since then I have been practicing 4-8 hours every week, and...
-
cant figure out a formula [Closed]
Hello, I need help figuring out a formula that will if two cells values match then the data in selected rows will go to one if that makes sense......
-
how to save next data entry in next target range [Closed]
Hello, I am running a macro using a command button that saves data from A3:AB3 to a7:AB7. however when I change the data from A3:AB3 and click sav...
-
create a macro which monitors the cell "c1" to be changed to "a" [Closed]
Hello, I hope someone can assist with this In my workbook; I have two worksheets labeled "log" and "master" I want to create a macro which monitor...
-
auto add or subtract between two cells [Closed]
Hello, This is probably a very simple question. I am trying to auto add or subtract between two cells. example: if B1 is greater or less t...
-
EXCEL VBA: Application.FileSearch Error in Running Excel 2013 [Solved/Closed]
Hello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to 2007).Up...
-
Please help - Finding missing rows between 2 sheet [Closed]
Hello, I would really appreciate your help with putting together a simple script to compare 2 excel sheets. I basically just want to find missing ...
-
Percentage [Closed]
Hello, how do I figure out the mark up percentage when I have the cost and sell price. cost Q2 1.14 sell P2 8.04 what's the per...
-
How to stop rows underneath being affected by a filter [Closed]
Hello, I have a filter set up for a table which works fine and is filtered when a quantity is entered in column D. However under the table is more row...
-
simple multiplication gives wrong result [Closed]
Hello, I am raja, In my excel 2010 when i am trying to multiply two cells of values 743.91 & 0.87 , the result is as given 646.88. But the actual...
-
column with dates not sorting/formating [Closed]
Hello, a column with dates is not sorting nor formatting. I have tried to do the suggested answer on the forum but to no avail. This is driving me cra...
-
Copy paste special into last row of another worksheet [Solved/Closed]
Hello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I am ...
-
how to create student exams record and printout using ms excel [Closed]
I wish to design student exams records using MS Excel afterward, I should be able to pull records of student using Matric_No and then print out the st...
-
EXCEL ** Sent e-mail after cell changes ( Excel macro ) [Closed]
Hello, I am looking for a solution on excel where when coloumn e is changed then email me with a coloumn plus the new e coloumn. Thank you for ...
-
Multiple Query in once button in same sheet [Closed]
Hello all, I have created two separate queries in excel VBA. I have given two different buttons for both queries and both are running successfully...
-
Transfer names from general sheet to separate other sheets [Closed]
Hello, So i have 3 separate sheets, the first is a general info sheet with names and other information on it, names are in column A. Each name is ...
-
Help for creating a macro [Closed]
Hi all. I'm here to ask for ypur help. I want to create a macro, that opens a dialog box and leting you browse your computer and open a new excel file...
-
complex nested if formula help... [Closed]
Hi, I'm new to this excel lark, i rather like it but am stuck, please can you wise people help me... heres a pic of what I'm working on... s...
-
status of the certificates [Closed]
Hello, i am raja, i have no.of certificates with issue date ,expiry date, last annual survey & next annual range. i attached sample sheet below .I...
-
Show Calculation on the first of the month [Closed]
Hello, I have created a spreadsheet with various calculations. I have it divided as monthly items, however, I prefer that a certain calculation o...
-
account formulas [Closed]
Hello, i am raja, i am working on milk processing excel sheet(it contains parts annexure II to annexure X) to start new business. anyone can help m...
-
Autopopulating across tables [Closed]
Hello, Hoping for some help with the following Excel conditional query. Hoping to automate so that Table 1 can autopopulate Table 2 with the re...
-
IF statement that adds 1 for specific text [Closed]
Hello, I have a spreadsheet that I have a column (I2-I48) that contains text for different ticket types. I am trying to create a formula that give...
-
Copy cell value between sheets if it matches a criteria [Closed]
Hello, I am looking for assistance in getting a formula to copy cell values between sheets if it matches criteria. Scenario - sheet 2 will have...
-
Find the last blank cell [Closed]
Hello, I am looking for a formula/method of finding a last blank cell in a column example column A 1 2 3 4 blank cell 1 2 3 ...
