Excel Forum
-
Macro Copy Paste from one to another based on cell value [Closed]
Hello, I have two sheets. Phase I and Phase II. Phase I I have columns A-J. Im looking for a macro which would copy columns A-F and paste it to she...
-
Automatically moving data [Solved/Closed]
Hello, I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I ...
-
Moving Data [Closed]
Hello Peeps, I'm having some trouble with using a macro to copy some data from one sheet across multiple. I have a master sheet that contains train...
-
how to create new workbooks from current workbook and move data [Closed]
Hi, I have the following workbook named "org_file": file_name data_1 data_2 File_1 r1 s1 File_2 r2 s2 File_3 r3 s3 . . . File_N rN sN I ...
-
Find word within cell & put "value from a list" in adjacent [Closed]
Hello, If cell A contains a short statement (e.g: 'supply of computers', 'supply of furniture', 'construction of water taps' and 'construction ...
-
help with macro VBA [Closed]
Hello, need to get a macro enabling to select a range of cells from one row and tranpose them into fixed position + get value from one cell and retur...
-
Try to scan one shell value and copy that entire row in other sh [Closed]
Hi, Sir/mam, I Have Two sheet named "carcase"and " shutter". In carcase sheet I have three nos. Of columns and 800 nos. Of Rows, in...
-
Create Macro to create worksheets based summary sheet [Closed]
Hello, I have an extremely long list of inventory items by department number. What I want to do is create a individual worksheet for each departme...
-
Autofill and open worksheet [Closed]
Hello, I am wanting to be able to search and open worksheets by typing the beginning of a worksheet. I have worksheets X,Y,Z and if I begin typi...
-
Search Cell for Multiple Text Strings, Return each found value [Closed]
Hello, I have a basic function to search a cell for a specific text string (in this case, the name of an application) and return a value to anoth...
-
Need VBA help [Closed]
Im pretty sure i will need VBA for this issue and I have no clue. I setting up an online store and I would like to track all my stock and transaction...
-
DUE DATE ALERT FROM EXCEL FILE WHEN WINDOWS STARTUP [Closed]
Hi, I need clarification that we can create due date alert from an Excel file when windows start up. Is it possible. If yes, Please advice how to c...
-
How to copy rows from one worksheet to another [Closed]
Hello, I am having problems writing a code to copy the rows from one worksheet to another, if certain criteria are met. A data dump is taken f...
-
How to create an text based spreadsheet [Closed]
I have access to Excel 2010 in an MS Office Suites. What I am try to do is to create a spreadsheet where I can enter a designated code (i.e. A1, A2...
-
location master file in excel [Solved/Closed]
I have location master file in excel. 1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi, 2) i want to brin...
-
Create new excel file from existing Excel file. [Closed]
Hello, I want to create a command button in a existing excel file that will pop-open a new excel file. (it will be good if it ask me "Save as" for ...
-
If "yes" in a column copy other cells to the next tab. [Closed]
Hi Guys, I have a sheet with participant names and a lot of other information about their attendance. What I am trying to do is to copy their name ...
-
Sales invoice in sheet1 and create summary table in sheet2 [Closed]
hi im working on sales/inventory worksheet. i made the sales invoices in sheet1, now i want all the details of sales invoice in sheet 2 to create ...
-
If Statements [Solved/Closed]
Hello, I have a scenario working with a time sheet. So basically the way payments work is from 30 minutes to 5 hours is automatically 5 hours of w...
-
Date formatting [Closed]
I would appreciate if someone can help me here. When I export transaction list from a Bank Account for example, the dates for some reason appear in d...
-
Need to look up multiple values and return a value from that row [Closed]
I have a large spreadsheet where within one cell I need to look at the entire file for a value in a certain column that matches the value on a certain...
-
Generate multiple sheets from master sheet [Closed]
I really need help in this, I am not very good in programming in Excel, if you can guide me that will be very helpful.Willr eally apprecaite it very m...
-
Macro To Copy Paste Value Until A Condition Is Met [Closed]
Hello All I could sure use some help on a Macro, i'm still a newbie The Case is : A1 is the sum of row 4 In A3 there is a value of 1, B3 t...
-
auto update data between sheets [Closed]
Hello, I have 3 sheets with data table all linked to sheet #4. how to set that every time a new data is entered on one of the 3 sheets it will ap...
-
formula [Closed]
Hello, I am trying to sum up the number of times a certain term is found in a spreadsheet and associate it with the number that is at the top of t...
-
Conditional Formatting in Excel 2010 [Closed]
Hello, In a celll that contains an if fumula which calculates if a cell is an "Actual" or Forecast" based on a drop down box selection, I would ...
-
Copy and paste entire row above specific cell value [Closed]
Hello Team I want to copy the first row in the below table and insert wherever the cell has a value as "105125" in column C . Your urgent assistan...
-
Vba code to run faster [Closed]
Hello, Not much experience with writing macros and with help from some awesome forums and googling have put pieces together. Having issue running...
-
Code to copy entire row into sheet two or three [Closed]
Hello, I created an excel document with different rows. I would like the ability to transfer these rows to either sheet 2, 3 or 4 based on either ...
-
Excel '10 - A Macro to Populate Month Column Based on Date/Sched [Closed]
Hello, I'm trying to work on a macro in Excel 2010 to auto-populate certain month (Jan-Dec) columns with an "X" based on the criteria of two oth...
-
Excel 2010 - A Macro to Populate Month Columns Based on Date/Sch [Closed]
I'm trying to work on a macro in Excel 2010 to auto-populate certain month (Jan-Dec) columns with an "X" based on the criteria of two other columns. ...
-
Counting Names Separately [Closed]
Hello, I would like to request that how to count names separately if in any one columns contains more than one names. Such as it is given below: ...
-
Conditional format range if one cell contains certain text [Closed]
Hello, I'm looking to use conditional formatting to make the cell next to a particular recurring word (for example, "new") highlighted. I have a s...
-
Copy a row based on a cell value. [Closed]
Hello, I have a very large spread sheet that I am trying to sort on to new tabs. Example tab one has the data and column A is the sorting column t...
-
Filter multiple worksheets based on data input in a master works [Closed]
Hi, I need some help with creating a VBA. I have a workbook that contains 6 worksheets. The first worksheet is a summary of the data listed in the...
-
Copy\paste [Closed]
Hello, Please help with below query Have 2 worksheets in same workbook and below macro is extracting data from other sheet based on firstname a...
-
Creating macro to search two values and delete them [Closed]
Hello, I´m new here. but I´ll try to do my best. I am looking for a macro where I can search in the column "I" all the values between two value...
-
Auto transfer from one tab to another [Closed]
Hello, I have been looking for ways on how to transfer a data in gdoc sheet from another tab. Example.. From Original File all data for ca...
-
Verifing-Vin Numbers [Solved/Closed]
Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...
-
formula [Closed]
I have multiple rows and one field is called product and the other is color. I am trying to figure out one formula that can be used on all the cells. ...
-
macro to search 2 values in a colum and delete them [Closed]
hi friends I´m new here. but I´m trying to make a macro where I can search in the column "I" all the values between two values. Those values are loc...
-
convert 4012016 and 24012016 in date format [Closed]
dear sir how we convert 4012016 and 24012016 in date format as dd/mm/yyyy in excel.
-
Dates from an IF statement [Closed]
Hello, I ve selected some dates via a simple if statement and can see the dates in the cell where I want them. But when I try to use them in anoth...
-
.xlsx, xls file [Closed]
Hi, I am not able to open the MS Excel file i receive in xlsx or xls format.How can i open it ? Thanks, Manwendra
-
Macro auto fill is not working [Closed]
Hi all I am trying to write for my excel .I am begginer and this first time I tred Macro. I wrote this code Private Sub Worksheet_Change(ByVa...
-
Weekly Totals [Closed]
Hello, I have a column of dates and a column of transactions. Often there are multiple transactions on the same day. How can I enter a formula in ...
-
To find a word in a sentence columnwise [Closed]
Hello, I am trying to find a particular word in a set of sentences columnwise. For example cells A1:A100 has the sentences and cell B1:B20 has the...
-
Counting a text Range if another text range has a value of.... [Closed]
Hi Everyone... Finding this really hard to figure out... I have Cell A1:A50 Containing lots of names And I have Cells C1:C50 Containing the Statu...
-
Modify the Macro [Closed]
Hello, I would like to request please modify the below macro. The below macro create a line (shape), in all sheets. If it once created (or it a...
-
If date exists (or any value) in B2, return value of 1 to C2 [Closed]
Hello, If for example there is a value of a date in column B (Row b2 or other) I need it to return a value of 1 in column C (C2 and corresponding)...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video