Excel Forum
-
Finding a particular row title and editing the value in next col Closed
Hello All, I have excel data sheet in following format Row Heading Row Value name XYZ address ab id 11 Now I need to write a macro which can ...
-
How to find a row heading and replace the data in the next col Closed
I have excel data sheet in following format Row Heading Row Value name XYZ address ab id 11 Now I need to ...
-
EXCEL/VBA copy multiple cell from other workbook into 1 workbook Closed
Hello, I would like to copy couple of cell from multiple workbook into 1 workbook using Marco/VB. Example: Source C:\temp\A.xls. Cell needed ...
-
macros to add numbers Closed
Hello, I need to create a button and on every click of that button it should add 1 to it. For Eg first click it should take data as 1 and second ...
-
change date format Closed
Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2010 Please solve my problem urgently Configuration: Windows 7 / Chr...
-
Macro to cut & paste a row on same excel sheet Closed
Hi, I have a list of values. You can consider them as text. These values are listed in a different sheet (in one column) on same particular Excel fil...
-
Comparing values from different sheets Closed
Hello, I want to Compare Values from 2 different sheets and if duplicate. I am thinking of values on Column A & B of sheet1 to columns D & E of sh...
-
Need a macro to searched data in another Excel Closed
Hello, I have a requirement , where in in one excel sheet i have data with 5 columns (A, B , C , D , E) now i want to search the excel on data wit...
-
Date format Closed
Hello, In my system date is in dd/mm/yyyy but I required in this format dd-mm-yyyy how it will possible pl let me know Configuration: Win...
-
automate vlookup Closed
two sheets.in one excel sheet columns are name, isbn, qauntity and many so.... in another excel sheet columns are only three columns are sku, isbn, q...
-
Excel info Closed
Hello, I am trying to enter data in one sheet and the total should be recorded in the other sheet. I want the total to be recorded in next cell a...
-
Date Interval within a specific span Closed
Hello, I need some help with calculating the time difference between two time stamps within a specific span (like 12.30 PM to 22.30 PM). For Eg ...
-
Apply Autohide Rows VBA code to entire workbook in Excel 2013 Closed
Hello, I want to apply this code to all worksheets: Private Sub Worksheet_Calculate() Dim LastRow As Long, c As Range Application.EnableEvents...
-
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
