Excel Forum
-
Help with macro needed..... [Closed]
Hello, Really the help of a pro here.... I have a master data sheet which details all payable items in our finance system and the user they are...
-
How to concanate two cells "line by line" [Solved/Closed]
Hello, I have one cell that has names separated with alt + enter. On the other cell, I have additional information on those names (also separate...
-
Text to n rows + copy row and insert n times [Solved/Closed]
Hello, I would appreciate your help with a macro I am trying to create in Excel 2007. My data is as follows: Column1 Column2 Column3 Column4 D...
-
Excel Macro - Set and Autofill a range? [Solved/Closed]
Hello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2, etc.)...
-
transferring data from one worksheet to anoth [Closed]
Hello, I have data compiled in different tabs - i have one sheet that is a sum of the data. There is text and numbers. How do I set it up that the...
-
Show date when amend excel sheet [Closed]
Hello, How to set a formula, so that everytime I do a change in a cell or a cell range - todays date appear in a different cell. In other words...
-
Excel Macro - Set and autofill a range? [Closed]
Hello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2, e...
-
How to copy informations from Excel to EES [Solved/Closed]
Hello, I wanna know if anybody can help me to copy 2 columns (supply) from Excel to EES (another program if anyone used it before) and then copy the...
-
EXCEL - Join date and text [Closed]
Hello, Below formula is returning date with numbers. can you please give me a solution where I can get date and text. =IF(F2="FIBSMSAPTREM"...
-
Copy the row and paste in a sheet w/ new col [Closed]
Hello, I am using Excel 2007. I am trying to figure out how to copy a row from one worksheet (in workbookA) and paste to a new row in a differe...
-
Excel 2007 Activex Option Button Default? [Solved/Closed]
Hello, I have two activex option buttons, Yes and No. How do I get it to display "No" as marked as a default? I have created a process that c...
-
Help please on Excel Search [Closed]
Hello, Need your expert opinion on what formula i should use. Quite new using excel. Scenario: A | B | C | D ...
-
Printing Sequencial numbers in excel [Closed]
Hello, I am wanting to print out purchase order forms with numbers on them in a order from 1-... If you know how i can do this please let me know as...
-
moving one excel column to new excel column [Closed]
Hello, I am a newbie in excel macro stuff. Would appreciate if someone plz help me to get a routine task automated. Let me explain what actually i...
-
Auto Emailing From Excell Based On Cell Date [Closed]
Hello, I have a new query here! I want to be able to send an email alert from to an email address based on date criteria: Example: Today's Da...
-
Excel date formatting into another column [Solved/Closed]
Hello, I want to check using IF function in one column and change the date format to another column from MM/DD/YYYY to has DD/MM/YYYY in excel 2010....
-
EXCEL [Closed]
Hello, GUYZ I NID HELP WITH THIS HUGE THING OVER HERE AS IT FOLLOWS 1. 1. Enter the following Data into the Spread sheet (marks 12) Aphache ...
-
Excel - transfer information from file [Solved/Closed]
Hi there! I have run into some problems when transferring information from one Excel file to another. I have a big Excel file with a lot of informa...
-
Add when multiple criteria is met in rows [Solved/Closed]
Hello, I'm trying to add numebrs when multiple criteria is met! I want to add numbers in B115:BF115, but only the ones that have an "A" in row B8...
-
How can copy data to bank cells only... [Closed]
Hello, I need to copy column A to column B, but only copy contain from cells a on column A to cells on column B only when cells on B are blank and l...
-
Referencing Data from a New Worksheet [Closed]
Hello, I am working with Excel 2007. I know how to fill in a worksheet based on information from another worksheet. This is a simple enough ta...
-
my browsers wont work [Closed]
Hello, my computer is a hp elitebook but is blocked by my school. the iternet works but when i pull up google chrome and internet expleror they come u...
-
Sumifs in Excel 2003 [Solved/Closed]
Sir I was using System with office 2010 and deriving some values by using "Sumifs" function. Now i am using Office 2003 system. When i copied the wo...
-
Matching/Copying data across worksheets [Closed]
Hello, I hope someone can help me with a little Excel problem I'm struggling with regarding some reports I am trying to pull together, here is a b...
-
Comparing/Matching data across in Excel works [Closed]
Hello, I have manually combined 4 separate reports into 1 workbook with 4 worksheets (1 for each report). Each row represents a separate job. T...
-
Macro for excel values to new sheet/new row [Closed]
Hello, I have an Excel worksheet with drop down menus for selecting 10 colours which links to a source sheet to show the pigments needed for produ...
-
Create new worksheet & copy the based on date [Solved/Closed]
Hello, Can any one help me to copy the excel sheet data from one sheet to another sheet? -> I have one excel sheet (name: Test.xls, sheet name: S...
-
Copy Worksheet to another Workbook (unopened) [Solved/Closed]
Hello, I want to copy a portion (A1:F54) of my current worksheet that I am working on, over to another workbook, that is not open. I want to use ...
-
Delete From first sheet and copying to other [Closed]
Dear Friends, i have problem with excel sheet. i have two excel sheet that have lots of data. i want to delete from first excel sheet then nee...
-
AutoRun a Macro in Excel based on sheet name [Closed]
Hello, I use the personal.xls which has many macros incorporated into it with shortcut names. The application I use that opens Excel names the sh...
-
Formulas not copying from worksheet to sheet [Closed]
Hi There, my excel has been doing some funny things lately. 1. When I copy a formula from one worksheet to another, the actual formula does not ...
-
problem in my excel sheet please help me out [Closed]
Hello, i hav poblem like... i hav code numbers for example.in coloum "B" if i enter dat code number i should get the name of the person or a deale...
-
Excel Formula [Closed]
Hello, I have a 2 colunm set of info on Sheet 3 in a spreadsheet (Column A numbers listed 1-600, and column B corresponding figures per number) wh...
-
Excel Copy Rows Based On Boolean? [Closed]
Hello Everyone, I've been using these forums for quite some time but I am completely stuck, so this is my first post. I'm currently attempting to Co...
-
Assistance needed in Excel 2010 [Closed]
Hello, Would it be possible for someone to help me with a vba problem in Excel 2010? In cell B35 I'm using the =TODAY() function and in C35 there ...
-
time recording on excel [Closed]
Hello, How can I have a code so that an employee just types his Employee # in let's say cell K1 and hit enter, so it will trigger the necessary inpu...
-
Microsoft Excel 2010 [Closed]
Hello, Hey can anyone tell me how to get data out of a cell into a macro. What I'm trying to do is get data of the internet by just clicking on a ...
-
Need an Excel Formula [Closed]
Hello, I'm likely having trouble finding a formula for this because I can't articulate properly what I want but here goes... I have two worksheets ...
-
Macro to copy data from 1 wrksheet to another [Closed]
Hello, Here is my situation. I have a workbook that has two sheets. The first sheet returns a set of cell values based on a link to an external da...
-
Move rows from multiple sheets to new sheets [Closed]
Hello, I have little experience with Macros and need some help. I have multiple worksheets each labeled with different weeks (i.e. "AUG 29 - SEP 3...
-
Macro Query [Closed]
Hello, I want to make a macro usable as follows: If I enter a value in a cell, then cursor should go to a certain sheet or the sheet having the...
-
Excel: copy cells under if statement [Closed]
Hi everyone, I'd like to copy a range of cells (year1, year2, year3,...) from worksheet years to worksheet customers if the cell name has the same...
-
VBA Macro to compare two worksheets [Closed]
Hello, I'm looking for some quick VBA code that will compare 2 worksheets (say sheet1 and sheet2) and copy the changes of sheet2 into the corres...
-
mass Spectrum for successful drawing in excel [Closed]
Dear friends. Please, does someone can help me concerning this issue resolving? I need a macro for solve a mass spectroscopy problem (mass spectrum)....
-
copying macro [Closed]
Hi guys, I'm new to macros and I need your help. I've got an excel file called "DATA.xlsm" and I need to copy some cells from another excel file, wh...
-
How to copy a range of cells. [Closed]
Hello, How to copy a range of cells from One excel file to another excel file. Ex: In file A, I want to copy the Cells from The Column C4 to t...
-
create a txt file and name it thru macro [Closed]
Hello, I am trying to copy content of a worksheet to a text file. What i want to know is how can i name the text file based on a given string in a p...
-
Unable to copy data from spreadsheet into ano [Closed]
Hello, I am unable to copy data from one spreadsheet to another. I can do it without filtering the data, but i need to filter in order to get the ...
-
Auto sheet date change [Closed]
Hello, I got 31 spreadsheets one for each day of the month named 1Jun10-30Jun10.Is there a way of changing these dates automatically to say 1Jul10-3...
-
Excel show formulas WITH NUMBERS [Closed]
Hello, I have a problem with making Excel write the formula with actual numbers. This is the text I want to get: A=1 B=3 C=A+B=1+3=4 In the t...
Subscribe To Our Newsletter!
