Excel Forum
-
how to connect db through input from userform [Closed]
Hello, i need to connect to db server with the inputs from the userform. here is the code. Please correct/add if any. user =...
-
Ms Excel match an amount [Closed]
hi, In Ms Excel Work book, I need to match an amount of more than one presented cheqs , which are cleared today, I want to lookup the exact...
-
Copying Data/table from one sheet to other [Closed]
Hello, I have copied data from one sheet to another. When I deleted from first sheet this is automatically deleted from seecond...
-
Multi-worksheet recording [Closed]
Hey gang, Long time reader, first time poster. I'm trying to create an excel file to help me stay organized. I know how to pull data from one...
-
Error in .SelectedItems during File Picking [Closed]
Hello Guys, I am trying to save a file path in a variable using .SelectedItems but the code is showing "Runtime Error 450". Kindly help me by...
-
Name Values [Closed]
Hi I have a sheet of people's names in C8 : C59 and D8 : D59. I would like a formula that can check these ranges and if it sees a specific name...
-
Need to seperate data from one cell into multiple. [Closed]
Hello, I want to seperate and pull numbers from a paragraph in one cell. Eg: Temp: 35, rain: 2.56, humidity: 80% I want to seperate...
-
Add data from one sheet to multiple sheet [Closed]
Hello, I have one concern that I have to split one sheet data into multiples sheets. Based on condition as below. Main...
-
how to find value from a column with unique random values [Solved/Closed]
Hello, I need a formula that can get me a value from a column that has unique values and return another cell from that row, can someone help...
-
Creating macros in Excel [Closed]
I need to create a macro in Excel to produce values with two demical places and a dollar sign in the personal macro workbook. I have no idea how...
-
Moving a row in Excel [Closed]
Hello, I need to move a row completely from spreadsheet 1 to Spreadsheet 2, which has same rows and columns. Can anyone explain me step-by-...
-
Macro for Extracting row information into a new tab [Closed]
Hello I am in need of a macro that will find a name in one column and copy the entire row into a new tab on the same work book. Ex. For...
-
Generating and logging jobsheets [Closed]
Hi, Is there a way of worksheets being generated by end users (for example, workers filling in a worksheet which generates the worksheet number...
-
ranking [Closed]
Hello, Suppose 5 students mark distribition is given bellow CODE STUDENT NAME SUBJECT: ENG 1 BAN 2 G.MATH ENG 2 TOTAL...
-
Cell borders will not print, colour fill does not work. [Closed]
Hello, I wonder if anyone out there can help, since upgrading (?) to Windows 10, cell borders do not print and the cell colour fill does not work....
-
Auto Generate workwheet from a list and from a template workshee [Solved/Closed]
Hello All, At the moment, I found out how to auto generate worksheet from a list. However, the generated ones are blank worksheets. May I...
-
No cell borders or text colour in Excel [Closed]
Since upgrading (?) to Windows 10, cell borders do not print. I also cannot change the text colour. Spreadsheets built before the update also...
-
Excel - A macro to rename existing worksheets based on a list [Solved/Closed]
I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just...
-
Inserting a picture with Path name in a Variable [Closed]
Hello Guys, I am getting an "Error 1004: unable to get insert property of Picture class" with the following code. Looking forward for your...
-
Inserting image in a particular cell in VBA [Solved/Closed]
Hello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding...
-
macro doubts [Closed]
Hello, How to create new excel worksheet in a same workbook and names of sheets should be same like...
-
merge cell [Closed]
Hello, What if the compared cell is a merged cell. Example, comparing the values in column C with the merged cell values in Column A,...
-
Exel formulas [Closed]
Hello, To find position class of the student in Mark card
-
A Macro to Create New Workbook and Paste Values Only [Closed]
Hello, I have a workbook with three tabs. I would like to create a macro for a command button that will create a duplicate workbook named...
-
Autoploting (Master to other sheets) [Closed]
Hello, I have a master file for all the transactions in one financial year. This file currently has 4 sheets: EGC,SSM,RSL,MF. The first three...
-
Macro - new sheet per name list and add template in each sheet [Closed]
Hi all, I'm a new comer here, but looking forwards to learning and helping others!. I am trying to create a macro that will: 1. create a...
-
IF statements with dates and criteria [Solved/Closed]
Hello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set...
-
Picture issues [Closed]
Hello, I am trying to add a picture to an inventory list. It is made to just write the item code and the details would be generated into other...
-
merge column [Closed]
Hello, Hello, Example, comparing the values in column C with the merged cell values in Column A, expecting the result of the values from...
-
Date, time (if the box says YES) next to someone's name [Closed]
Hello, Is there a way for me to have the Date, time (if the box says YES) next to someone's name? http://imgur.com/a/SYpcV For example...
-
Help with Excel Formula [Closed]
Hello, I am a beginner at Excel. Trying to figure out formula for: IF DATE in column A is greater than DATE in column B,...
-
if a cell has specific data, copy entire row to new worksheet [Closed]
Hello everyone :) This is my first post and I'm really needing some assistance if at all possible! I am a school teacher, trying to create a...
-
Date format [Closed]
How do you set the Excel date format to display "Wed 09 Nov" and not "Wednesday, 9 November 2016" I have tried several combinations to no avail....
-
copy information from the one excel spreadsheet to the other [Closed]
I have two excel spread sheets. Basically I need to copy information from the one excel spreadsheet to the other. Here is the tricky part. the...
-
Difficult Lookup formula [Closed]
Hello, I have a difficult question that may not have an answer. At least, I haven't found a formula that works. A ...
-
duplicate values in multiple columns [Solved/Closed]
Hello, I'm looking for a formula for a case mentioned below: Consider we have values in three columns I need to find a formula which...
-
Copy data of one sheet to other sheets [Solved/Closed]
Hello, I want a VBA code or excel formula that automatic copy of data from one sheet to another sheets(either sheet 2 or sheet 3...etc)..suppose...
-
excel 2003 auto data copy criteria wise sheet to sheet vba code [Closed]
Dear Concern, I have one excel data file like below But I want to make a automatic data copying system on data sheet to another sheet using...
-
How to activate the Button as Activecell [Closed]
Hello Guys, I would like to know if there is any way to make the cell in which the button is inserted as the ActiveCell when i click the...
-
Report sheet [Closed]
Pls assist me on how to gives a class position of students after tabulation of the finals scores based on highest to Lowest
-
Respective names required [Closed]
Hello CCM, Please give me solutions to solve my problem.. 1) I have created 2 worksheets, one sheet having two columns like...
-
Want to implement a Macro to Find and Copy to another sheet [Closed]
Hello, I have tried to implement a Macro on Excel for my data, I have a search box made for my data on cell D1 I want to make a macro in...
-
Compare 2 MS Excel sheets and copy data to a new one [Closed]
Hi all, I would like to know what to do for the situation below - I have 2 sheets named as "Current" & "New" and they both have the same...
-
Copying & pasting data in next available row in same worksheet. [Solved/Closed]
Hello, I would really like assistance to write a vba code for a macro (using a drop down list) that copies data from A4:E4 and pastes it down...
-
Value from matrix table [Solved/Closed]
Trying to get rate in G14 that comes from the matrix E14 is a list of A3:A10 F14 is a list of B2:J2
-
Trasfering data with vba [Closed]
Hello, I have sheet1 of data with 2 columns with 26 row And i want to copy this data to sheet2 but when i copy this data it overwrite the old...
-
Inserting Picture with Variable [Closed]
Hello Guys, I am trying to insert an image into a particular cell by calling the value stored in the variable via an InputBox. The following...
-
how to auto insert photo in excel with matching cell and pic fil [Closed]
Hello, I have a list of photos names that I would like to auto insert the photos into the cell according to the name. For example: in cell B1...
-
Macro question: copying different value x number of times [Closed]
Hello, I am trying to paste a different value [which I copy from cells(1,i)] every 9 rows down column A. For example, will copy value B1 and...
-
looking up same value and returning location [Closed]
can i look up the same value in 2 separate spreadsheet and return the location? Spreadsheet 1 A- item number B item description Spreadsheet...
