Excel Forum
-
multiple sheet to one sheet without blank cells [Closed]
Hello, Hello, i have an excel file with more than 250 sheets, i want to merge these files into one sheet, i dont want to copy blank cells an...
-
Checking if value in 2 or more columns are repeated in a table [Closed]
Hi Guys, Please help with below table, NAME SURNAME ID NUMBER STATUS NAME1 SN1 ID001 CLOSED NAME2 SN1 ID...
-
generating alphanumeric code [Closed]
Sir, Can anybody help me in writing vba code for excel to generate alphanumeric code having first entry as L,P,G,T(based on a condition), next four...
-
SAS datasets [Closed]
Hello, there is a sas data set like: col1 col2 1 1 1 abc 1 2 2 def 2 2 3 3 3 ghi 3 3 expected outp...
-
formula - If C2 is not blank, and b2 Is blank, then copy c2 to [Solved/Closed]
Hi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...
-
Private Sub [Closed]
Hi Team, Please request your assistance in creating a private sub macro, I am looking to create a file with all the data entered in worksheet 1 to ...
-
Copying Data From 1 sheet to another [Closed]
hello i had made a bill in excel and also entered module of converting indian rupees in numbers.but if i copy my sheet to second sheet to prepare bi...
-
Excel Challenge! [Closed]
Hello, I have text in A1:A2554 and text in B1:B1962. Although the columns do not have the same number of rows of information, it has relative inf...
-
data transpose [Closed]
Hello I'd like to learn how to transpose my data in excel. Here is an example. Buy side/Sell side New York Paris Vienna Barcelon...
-
Need Help With Macro For Break Management Of Employees [Closed]
Hello, Please help in defining a macro to record and monitor break timings of employees on shift. Requirements: Will need a Front End which w...
-
Private sub [Closed]
Hello, Need a assistance in creating a private sub macro, I want all the data entered in worksheet 1 to auto update in worksheet 2. here I may e...
-
how to sort data according to shift [Solved/Closed]
i want to sort according to person shiht
-
VBA How to copy output-range if changing the input-range [Closed]
Hello, This is a question regarding VBA and how to automatically copy and paste a range in one worksheet if a change is added in another worksheet...
-
help, error 1004 something is wierd with my code [Closed]
Hello, so this is my code. What i want is this thing to work but it doesnt. the bold marking is the thing that my debug stops at. Basically what i wan...
-
Macro that copies a worksheet, renames it and copies data [Closed]
I am trying to create a macro that when I select an option from the dropdown list in cell E3 it creates a copy of another sheet in the workbook. ...
-
Transfer data and then apply formula [Solved/Closed]
Hello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...
-
sum every column and want that summation to transfer automatical [Closed]
I have four columns of random data (numbers) on one excel document (excel1). I want to sum every column and want that summation to transfer automatica...
-
command button (VBA) to update a record. [Closed]
Hello, I have created a userform for searching & adding records to a worksheet, but as I am completely new to VBA I am stuck. I wish to create a bu...
-
convert date into words(english) in excel 2003 or 2007 [Closed]
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Twenty Tw...
-
Macro to copy/paste specific range every 3 rows [Solved/Closed]
Hello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for the fi...
-
Need urgently to find a macro in excel report across sheets [Solved/Closed]
Hi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the workbo...
-
change cell by clicking on another cell [Closed]
Hello, I'm looking for a Macro/Formula to change value of a cell to (the row of the original cell I click on - 2). Is this possible? Cheers al...
-
Excel macro to take screenprint,paste in word document(iteration [Closed]
Hello, I have desktop application also a website. I would like to make a macro tool includes a command button by clicking the available screen sho...
-
"Run-time error '5': Invalid procedure call or argument [Closed]
Hello, On my PC while opening the excel file I am getting this error for all excel files. Please do the needful ASAP Configuration: Windows 7 /...
-
Auto Formatting [cell range] in multiple workbooks & sheets AD [Closed]
Greetings Team, I need kind assistance to help creating a macro that can help my team in formatting their worksheets on 10s and 100s of workbooks i...
-
Creating a Macro [Closed]
Hello, I am trying to create a macro that takes information from 6 separate sheets and pools them into one excel document. Essentially it would ta...
-
Excel Challenging - Please Help [Closed]
Good Day Everyone. I'm stuck on the below situation and your help will be much appreciated. Let's call as: Worksheet] 1: WorkSheet]...
-
Conditional Formatting Based on another cell [Closed]
Hello, I'm trying to make a budget spreadsheet and want to format the cells if there is an omission. If a value has been entered into cell C3 ...
-
Comparing two sheets [Closed]
Hello guys, trying to do a spreadsheet at work for a stock take but a little bit more automated. The basic sheet is there but the csv that comes fr...
-
NEED AUTOMATICALLY CHANGED AMOUNT PERCENTAGE. [Closed]
Hello, I need to help to ms excel sheet PERCENTAGE% 0.25 ENTER AMOUNT PERCENTAGE% 25,000.00 AUMATICALLY CHANGE 300000 AUMATI...
-
Need macros solution, thanks in advance. [Closed]
A B C D 887806009723 B00A3ZFW7I 887806009723 887806009730 B00A3ZFWUU 88780600973...
-
count if rows contains specific year [Closed]
Hello, I need to count how many rows contains a date with a specific year, but with the following doesn't work: =COUNT.IF(D3:D3394;"*2014") I cha...
-
Insert a row after "," in a cell [Closed]
Hello, I have a 2 columns such as below: Name Rules John T3456,T4567,T6799 Cersei T5643,T4532 I would like to have a macro that...
-
Checkbox [Closed]
I'm trying to use an Excel worksheet to take attendance. I've been able to find a solution using Apple's Numbers, but not so with Excel. Any ideas?
-
how to convert number to word in excel using formula [Closed]
Hello, HOW TO CONVERT NUMBER TO WORD IN EXCEL USING FORMULA Configuration: Windows 7 / Chrome 43.0.2357.130
-
Copying text to different sheets based on criteria [Closed]
Hello, I have a large speradsheet that records activity. I want to copy a row of items from one sheet to another if the status is 'done'. The if...
-
Excel macro copy cell based on date. [Closed]
Hello, I got this kind of problem. Sheet1 for example cell A1 contains salesmen margin of a month and B1 contains drop list of months and Sheet2 has...
-
Apply a number to differentiate cells with same value [Closed]
Hello, Can someone help me please? Here is my issue. So I have a long list of memberships. The issue I have is that I have one primary member that ...
-
Formula to sum information if it relates to certain text [Closed]
Hi I am trying to analyse some data. In one column I have the description of the data and in another column I have the cost. The descriptions are all ...
-
apply a number to differentiate cell with same value [Closed]
Hello, So I have a long list of memberships. The issue I have is that I have one primary member that has a spouse and 2 kids and each one needs a ...
-
A Macro to add data from sheet 2 to sheet 1 with repeating rows [Closed]
Hi, i want to create macro that would take repeat rows from sheet 2 to sheet 1 X number of times e.g Sheet 2 would contain following data Code Des...
-
Macro for transferring data and automatically puts it in order [Closed]
Hi all, There were so many topics to find macro's that i had to browse a lot but couldn't find what i was looking for on the moment so i thought i ...
-
how to convert date into words(english) in excel 2003 or 2007 [Closed]
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Two Tho...
-
Input data from an input form to a permanent file [Closed]
Hello awesome forum people! re: EXCEL worksheets Is there a way to be able to input data into a form on an EXCEL worksheet, containing Name, Addres...
-
Create Multiple Workbooks in a particular format from a Table [Closed]
Hi, I want to create a macro wherein I can create multiple workbooks in a particular format from the data from a master table in a excel workbook. ...
-
Error trying to populate new worksheet using macro [Solved/Closed]
Hey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...
-
add string only if a text is present in a cell [Solved/Closed]
Hello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...
-
FORMULA FORMATION HELP [Closed]
Hi, I am just starting to understand Excel. I have a database that is used to enter our employee's time slip information, therefore, there is about a ...
-
combining 5 workbooks into one and removing duplicates [Closed]
Hello, I have 5 address books saved onto separate spreadsheets and I would like to put them all together to make a master Address book. I would nee...
-
Copy cell from another sheet where cell is value...? [Solved/Closed]
Hi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...
Subscribe To Our Newsletter!
