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...
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 ...
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...
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...
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...
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 ...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
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...
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 ...
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...
Hello, I have 2 sets of data: a b c d MEL MEL2 BOB BOB2 yx124 $100 xyz ...
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...
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...
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: ...
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 ...
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 ...
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...
Hello, I am currently working on excel to copy rows from master sheet to individual sheet. These individual sheet have to be automatically filled...
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...
Hi Guys, Please help with below table, NAME SURNAME ID NUMBER STATUS NAME1 SN1 ID001 CLOSED NAME2 SN1 ID...
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...
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...
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 ...
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 ...
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...
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...
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...
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...
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...
i want to sort according to person shiht
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...
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...
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. ...
Hello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...
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...
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...
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...
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...
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...
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...
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...
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 /...
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...
DON'T MISS