Excel Forum
-
Autorun different macros dependent on dropdown and cell value [Closed]
Hello, I have 4 macros activated by 4 buttons these are macros stage2, stage3, stage4 and stage5. If I enter values into fields D7, D8 and D9 then...
-
Macro needed to find A and look at B [Closed]
Hi this is my first ever post! I am setting up a userform in VBA that allows data capture. This form currently copies the information entered to ...
-
Condition formatting on changing cell color based on another cel [Closed]
hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text. For example I have cell A1 with Text Pa...
-
how to read the file from shared PC in same work environment [Closed]
Hi all can anyone please guide me on this. I want to open the file which is stored in shred system in our work environment. those will be accessible...
-
to copy data to other workshet by suming the value based on co [Closed]
Hello, I am having table like below with large data in DATA.xlsx file Pls see attached file for table details My requirement is to selec...
-
Auto - input box/date timestamp [Closed]
Hello, I am creating an inventory spread sheet. I am using Excel 2013. I have data from A2:O1243. I have several macros running. My macros are as ...
-
Autorun Macro on various cell changes [Closed]
Hello, I have 4 macros activated by 4 buttons these are macros stage2, stage3, stage4 and stage5. If I enter values into fields D7, D8 and D9 the...
-
compare filename1 sheet1 with filename2 [Closed]
Hi all, i need help, i want to compare filename1 sheet1 with filename2 sheet and result in filename3 sheet as pass or fail. filename1 sheet1 insert ...
-
Autofill on excel or formatting? [Closed]
I have two separate worksheets. When a customer calls in I will fill out there name, address, phone number, and email address in worksheet 1. I was th...
-
Excel / CSV query [Closed]
I will be receiving a weekly CSV data set of holiday information that I need to do the following with: Save into XLS format Create 3 identifier ...
-
auto populating from one spreadsheet to another [Closed]
HI there, this is my first question and I am hoping someone can help me please. I am setting up a database in excel and I am an basic to intermedia...
-
need formula to populate total sales for each employee by month [Closed]
Hello, Im working on a spreadsheet and i cant come to a formula that works for me. I want to total the amount of apples each employee sold e...
-
get data present in Row1 of Sheet1 copied into row1 of Sheet2 [Solved/Closed]
Hello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...
-
spellnumber function [Closed]
Hello, Spellnumber function which was working in excel version earlier than office 7, does not work from office 7 onward versions. I can not get t...
-
copying rows to certain worksheet [Closed]
Hello, I think i can accomplish this without a macro but can figure it out. I have a project list on sheet1, I would like to copy a projects row to...
-
Merge cells with different value into one row [Closed]
Hello all, I would like to do a VB macro in MS Excel 2010 which will do the following: Before applying macro: Row Number Year Code ...
-
Conditional formatting a cell based on another cell [Closed]
Hello, What I'm looking to achieve is a font in column A to be a colour (blue) if there is no text in column S, however, if there is text in colum...
-
lookup match difference [Closed]
Hello, I have 2 sets of data: a b c d MEL MEL2 BOB BOB2 yx124 $100 xyz ...
-
I need a Macro to Add Another Sheet to the Current Workbook [Closed]
Hello, I have a public file that I want a macro to import that worksheet into my current workbook. I have payload data that gives me timestamps an...
-
Last value in a row [Closed]
Hello, I want a cell which is a summary of the entire row values, but it should display the latest value in the row.Suppose I have entered a value a...
-
How do you specify a different location to save the file to? [Closed]
Hello, I was wondering if you could tell me how to save this file to a different location than where the current file is saved? Configuration: ...
-
sheet in which the next column gets automatically filled [Closed]
Hi I need an excel sheet in which the next column gets automatically filled the moment existing cell is filled.Suppose, I have 10 employee names and ...
-
copying data fromm different excels into one new sheet by cond [Closed]
Hello, I have 2-3 different excel sheets. by specifying the criteria ie if the category:ABCD then copy all the data pertaining to match should be ...
-
Excel Macro to Copy Filtered Data to a New Sheets [Closed]
Hello, I am writing an Excel macro that: 1- For every name on a list of values, creates a new sheet using the value from the list (DONE) 2- Filt...
-
Copy rows from master sheet to specific sheet [Closed]
Hello, I am currently working on excel to copy rows from master sheet to individual sheet. These individual sheet have to be automatically filled...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video