Excel Forum
-
Transfering data from one sheet to another [Closed]
Hi all, Nice to be here! I have to transfer data from one sheet to another whenever the status of the case is closed. I have created the dropdown li...
-
automatically copy the values from the active row from sheet [Solved/Closed]
Hello, Struggling already for a couple of days.... so a help would be more than welcomed Need to write a macro in Excel which would: automaticall...
-
Date Formats [Closed]
In Excel, why do I set date format to custom mm/dd/yy yet have to enter the date as yy/mm/dd for it to appear correctly on the worksheet. I used ...
-
Automatically transfer information from Sheet 1 to Sheet 2 [Closed]
Hi, How can I automatically transfer data from a cell in Column A in Sheet 1 to Column A in Sheet 2? Once data is copied over into Column A in Sheet...
-
Column Differences [Closed]
Hi. Thanks for welcoming me to this forum. I have a problem and I am hoping someone here can help me. The problem is as follows: I have 2 worksheet...
-
building a macro that allows to pull different year data [Closed]
I am trying to do the following in excel: I have one master sheet where I have the following columns (name, score, weighting), and the following row...
-
Macro to copy entire row to next workbook [Solved/Closed]
Hello, Configuration: Windows 7 / Firefox 50.0 I have the following macro to copy entire row when the column has a capital X. I would like...
-
Macros / VBA - Sending Rows to New Sheet [Closed]
Hi All-- New to programming, trying to make an efficient Excel program to use to sort and send certain data to certain sections of a separate sheet. ...
-
Column differences [Closed]
Hi. I have 2 worksheets. There are around 36000 rows of products on each sheet, although the sheets are not an exact match ie there are some product...
-
Transfering data from one sheet to another [Closed]
Hello! I am running my own business. There are many ways my below query help me in my business. I buy raw material for my business like Nickel, Zin...
-
Auto Populate Master datasheet [Closed]
Hello, I am trying to build a master data worksheet that initially contains about 5000 records that updates from the data entered into 7 separated w...
-
Email Notifications from the Work Book [Closed]
Dear Any one help me on the below I had a workbook with 3 to 4 sheets in it. if some is changing or updating in anyone of the sheet. i need to get t...
-
Compare Value Randomly [Closed]
Hello, Hello, I have 4 columns: vendor_url reprice_sku Item ID URL for Item ID URL1 2...
-
Adding a specific number of rows between data change in excel [Closed]
Hello, please advise on the code for adding a certain number of rows in the excel data at a change in value. I want to add 12 blank rows between th...
-
embarrassing [Closed]
Data is automatically (or unintentionally) are copied from one worksheet to another taking up time and memory. How can I prevent Excel do this? Is the...
-
A and B column query to provide Sum of column C [Solved/Closed]
Hello and thank you for your help. Please use this scenario for reference: - A B C 1 abc x 1 2 abc y 2...
-
search, find & display [Solved/Closed]
Hello, I have been manually filling out the week no's, in a budget sheet, but want to try and auto populate. I have a table with dates and Week No...
-
VBA Help - Copying Rows into a new sheet, based on 3 Characters [Closed]
Hello Friends, I am looking to build a VBA Macro that extracts the entire row of information based on the first three letters of Column C (Postal). ...
-
Copy past using VBA [Closed]
I am in Excel trying to copy data from from one worksheet to another. The idea is new data would be added to the next row each time data is added. Eac...
-
I want to validate the data format [Closed]
Hi I need to verify/validate the data in a column, it should be "AAAA-16-0001" format. If the data is not in the specified format, i need to have a...
-
automatilcally transfer to data to other spreadsheet [Closed]
Hello, I have one master sheet and 12 monthly sheets, I want to transfer the data from Master sheet to all the respective monthly sheet, automatical...
-
Excel formula query [Closed]
Hello, If I enter 1 in column A1 I want column C1 to equal the content of column C2 Configuration: iPad / Safari 9.0
-
Verify data format in all rows for a column [Closed]
Hello, I have 2 worksheets (sheet1, sheet2) which has about 50 columns each. The sheet has customer informations for the company for 2 different yea...
-
Transferring data between sheets [Closed]
Hello, Thanks in advance for reading my question. I am have two excel sheets. The first sheet contains the columns: first name, last name and i...
-
coloring line indicated the name, by the table where there is th [Closed]
Hello, I have four tables with four different colors, are 4 different categories of staff. First with font color blue Second with font color red...
-
Autofill based on filename in same/different folder. [Closed]
Hello, I'm looking for a way to pretty much automate part of my job, which is creating manhole sheets. In folder there are 10 files, each is calle...
-
Copy query from all worksheets of same workbook [Closed]
Hello, Please help me with below, I have 600 worksheets file, out of which i want to add only fiest column of all sheets in one master file and th...
-
conditional formatting based on multiple values [Closed]
Hello, I want to color my cell if one of few drop down list is picked for example: if appe or orange are getting picked, it needs to color it in gr...
-
I NEED A HELP IN VBA CODE [Closed]
i'm trying to create stock inventory by 3 userform in different worksheet is Stock Inwards, Outwards and Sales Return but i transfer qtys to last wor...
-
Attendance sheet [Closed]
Hello, i am using excel for attendance card scanning, in that sheet i have applied v lookup formula for getting the employee name and other informa...
-
Change cell color based on another column [Solved/Closed]
Hi All, I am not very good at excel, however I am looking for a solution for the following problem. There are two columns (Column A and Column B...
-
Default ´Value in a Cell for User to fill it [Closed]
Hello Guys, I would like to know if there is a way to input a default value in a cell so that it can indicate the user about the information to ...
-
Underlining a Value in a Variable [Closed]
Hello Guys, I have a variable which contains some value. I would like to underline it before printing it into a cell. I have used the following lin...
-
Incorporating the text formating when Formula in used [Closed]
Hello Guys, In Cell A1, the text is "abc" (Note that "abc" is underlined). If i choose cell B1 and apply a formula as "=A1", the cell B1 shows "ab...
-
Concatenating a variable.formula and variable.value [Closed]
Hello Guys, I would like to know if there is a way to concatenate a variable.formula and variable.value. I have written the following lines of...
-
Transfer data between excel sheets [Closed]
Hello. I have converted pdf files into excel. So each pdf file presents sheets in a single workbook. Now the issue is I have around 100 sheets. But...
-
Best resources to learn about PowerPivot? [Solved/Closed]
Hello, I'm expected to use PowerPivot extensively - meaning with complex data models. What would you recommand for a newbie who wants to learn?
-
cond format for date column [Closed]
Hello, I am trying to apply cond. format to a date colunm to change color according to todays date +30, +60, and +90...all being different color fi...
-
in some cells dates format are changed [Closed]
Hello, the prblem is that when i upgraded to office 10 then formate of dates are changed in some cells of the worksheets and whn i changed the forma...
-
Excel vba to work on ALL workbooks - please help. [Closed]
Dear valuable members, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cell...
-
Excel vba to work on ALL workbooks [Closed]
Hello, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cells(Rows.Cou...
-
Find variable and paste name of sheet in another workbook [Closed]
hello, i need to search a variable in an existing workbook and then copy the name of the sheet in which it si contained and paste it against the varia...
-
transfer specific data on to a second work sheet [Closed]
WORKBOOK 1 Services ALL - contains columns A-F (a- Qtr, b-Locality, c-Date, d- first name, e- surname, f- Comments) I have a WORKBOOK 2 with work...
-
covert the date format into text in excel [Closed]
How to convert birthdate in text format in excel
-
Append & Copy Data Automatically from Tab A to Tab B [Closed]
I'm trying to automatically append any new data from one excel tab (ReportExport) to another tab (MappingTool) if the vlookup on the MappingTool tab i...
-
Wildcards or values in a macro? [Closed]
Hello, I created a macro (by recording) that looks at the names and picks them based on the full name. Is there a way to just use a wildcard? Instea...
-
How To Make an Excel Sheet Equal to Another [Solved/Closed]
Hi, I'm new in Excel, and what I'm trying to do is this: I want to make an entire sheet equal to another, except for one cell, so if I change somethi...
-
Macro to copy a sheet to a new sheet after a filter and sort [Closed]
Hello, I have a recorded macro that picks specific values in a list and sorts them to display only ones with those values. What I would like to do ...
-
Macro to change the find option from 'workbook' to 'sheet' [Closed]
I cannot find a macro anywhere to change the find option from 'workbook' to 'sheet'? Any help greatly appreciated.
-
contain word, return value [Closed]
Hello, I would like some help. cell a1 contains London - abc cell a2 contains Tokyo - abcd cell a3 contains Singapore - abcde I would like...
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account