Excel Forum
-
Copy and Paste certain columns based on dates [Solved/Closed]
Hello, I am trying to create a macro that will look at a list of dates in column B then copy and paste the data in column C and D to another sheet...
-
compare two columns in excel 2010 [Closed]
Hello, Configuration: Windows 7 / Safari 535.1 I need to compare two columns say column A in worksheet1 with column A in worksheet2, colu...
-
Excel sorting [Closed]
Hello, I'm an Excel novice and I need to sort a list of email addresses on the company name or everything that appears after the @ sign. How do I...
-
copy data from one excel sheet based on type [Closed]
Hello, I have a scenario where there is a main worksheet in the workbook which contains information in the below format Item code Ite...
-
Make an excel sheet [Closed]
Hello, I HAVE TO MAKE A EXCEL SHEET LIKE THE ATTACHED ONE.HERE Cellular Accessories,Cellular Activations AND Performance Metrix Summary ARE THREE ...
-
Delete old information from Excel 2003, VBA [Closed]
Hello, My appreciation in advance for any responses to this. I have a sheet which measures certain things on a daily basis, there is a "Sat", "...
-
VBA or change settings for "Picture format " [Closed]
Dears, If any one can help me either by changing some settings or through VBA code. The case: I have excel workbook including 100 worksheets fo...
-
Excel: exporting rows that meet criteria [Closed]
Hello, I'm new to this forum and also to macros so please excuse any technical slip-ups. Thanks in advance for help! I currently have two Excel wo...
-
Searching text in excel using macro [Closed]
Hello i want to search words in excel using macros. i have two sheets(sheet1 and sheet2). i have a column,say E, which has 50 text rows. i need ...
-
Access 2010 - table with same fileds and rows [Closed]
Hello evryone, need your kind help with the below, i'm using Access 2010 and i created a main form , from which i want to let users to open new ...
-
compare 2 excel sheet and combine uniq data [Closed]
Hello, I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All I want is to combine both with no redundant ...
-
Need help figuring out a formula or macro [Closed]
Hello, I need some kind of formula or macro that can do the following: If the exact value of a cell in column C is found anywhere in column A, ...
-
Submit button Macro [Closed]
Hello, I need a macro that will be assigned to a "Submit" button that will move data from Column H on my "Data_Entry" sheet to a different column ...
-
In Excel formula I need to use dynamic range [Closed]
Hello, I need to use dynamic range for excel formula for example If condition is unmatched from next step I need to terminate the counting & start ...
-
Excel help required! [Closed]
Hello, Hoping you guys and gals can help. I am currently uploading many items on to a website. I have a spreadsheet with all the different supp...
-
Macro to Import Data Excel to Excel [Closed]
Hello, Let me preface with the fact that I am using Excel 2003, pretty fluent with Excel in general, but new to the macros and visual basic - alth...
-
Excel 2003 [Closed]
Hello, In one worbook (Best Price) I have the following data where Coloumn A, Row 1 is a heading (Range Code) and the data starts from A2. Ro...
-
Sharing an excel sheet [Closed]
Hello, I am looking for a way to share an excel sheet with multiple people. each person given a password to see their specific info only. This is ...
-
Spread sheet / Macro/ Formulas Help! [Closed]
Hello, I would like to create a spreadsheet that has 4 - 5 specific fields where individuals can type in account numbers, names, a drop down where...
-
drowing data from one sheet to another [Closed]
Hello, Need your kind help with this cause i have no idea how to excute this. What i need is to drow data from one table in sheet 2 to the main ...
-
Hide Columns [Solved/Closed]
Hello, I recorded a macro to hide some columns (says, column M to O). However, when I tried to run the macro again, the macro hide all the columns f...
-
Importing data from 1 Excel Sheet to another [Closed]
Hello, I have a program that exports the daily maximum temperature recorded into an excel spread sheet. Column A Row 1 Date Column B Row 1 Tempera...
-
Transfer of excel data from a row to another [Solved/Closed]
Hello, I have this excel sheet with numerous rows having columns A,B,C,D &E.column A is numbers & other columns hav data in text.I want to transfer...
-
Excel [Closed]
Hello, I was wondering if anybody knew how to take a list of tasks, associate a number with each task, and then be able to put the number in a cell ...
-
Macro for copying and replacing data [Closed]
Hello, I'm looking for the best way, which I am assuming is a macro to copy data from one spredsheet to another. The macro must copy all data from...
-
Macro to Copy and Paste [Solved/Closed]
Hello, I would greatly appreciate any assistance with creating an Excel macro that will copy information from cells A1, B11:D11, A13, B23:D23, et...
-
Macro: Transpose multiple rows into 1 column [Closed]
Hello, No previous experience with macros, so any info would be helpful. Suppose I have names in Column A, with 4 scores in B, C, D and E. I wo...
-
Excel Macro Help [Closed]
Hello, I was wondering if it were possible to have a macro that would work for different sheets for having the column be pasted as long as the nam...
-
How to Pull content from 4 cells to 1 cell [Solved/Closed]
Hello, How can I pull content from 4 cells to I Cell in a specific format so that I have it displayed like this: sm=12.00/W123/F456,MD=13.00/W456/...
-
Excel 2007 Macro [Closed]
Hello, Could you help me in writing a macro for exporting data from certain cells in sheet 1 to sheet 2. I use Windows 7 and excel 2007 Than...
-
VBA 2010 Open files in current folder loop [Solved/Closed]
Hello there, Think this is a relatively simple code and I've found examples but can't quite piece it all together to do what I want to do. I want t...
-
Excel Working time macros [Closed]
Hello, I am looking for a macro to extract data between certain hours. My csv has start_time and end_time of driver trips. I would like to see ...
-
Excel Macro Needs Help Fast [Closed]
Hello, I'm currently trying to introduce macros in my reports at work. Everything works fine but there's one thing that I just CAN'T find an answe...
-
VBA 2010 Saving workshts-workbks new file [Closed]
Hiya, I've found a fabulous bit of code that saves the individual worksheets as individual workbooks. It works brilliantly and I'm just wondering ...
-
Macro to transfer data [Closed]
Hello, I am trying to create a worksheet for stock control. When I add the quantity and items needed, as well as the job reference, signed out by...
-
VBA locate & delete words within a sentence [Solved/Closed]
Hello, I know this is probably very easy but I'm having trouble figuring it out. I'm trying to find a code that will identify key words within a s...
-
releasing filter before running a macro [Solved/Closed]
Hello, dear all friends, good morning. I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will be able to store ...
-
undo all filters before running a macro [Closed]
Hello, dear all, I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will store some cell contents of the invoice...
-
Highlight Rows with Conditions met [Solved/Closed]
Hello Friends, I desperately need a macro to Highlight /or separate rows when specific conditions met. sample file enclosed. Link http://www.spe...
-
excel data comparison and copy data [Closed]
Hello, Sheet1 details A:employee no (employee no appear more than once) (a2:a5720) B: name C:address1 D:address2 E:address3 F:address4 G:pin ...
-
Mail Merging from Excel to Excel [Closed]
Hello and Good morning Everyone. I will appreciate your expertise on this question because I have tried attempting several avenues and still didn't...
-
Sharepoint link to Excel via a cell variable [Solved/Closed]
Hello, Configuration: Windows XP / Internet Explorer 7.0Hello, Wonder if any of you gurus can help with the following, as it has got me totall...
-
Excel, equating 2 columns formula [Closed]
Hello, I'm trying to take 3 columns and make them a bit neater. Say column A came from a customer listing such things like Apple, Orange, B...
-
reading differrent excel sheets [Closed]
Hello guys, I have to consolidate the data from different excel sheets (+/- 20/ files) from differrent excel files (20) how can I do it quickly in ...
-
macro to capture timing [Closed]
Dear All, Can anyone please assist me in composing a macro to capture the break timing of my team members. Am desperately in need of this macro to...
-
Remove "Calculate" from Excel. [Solved/Closed]
Hello, When opening a saved sheet with data in excel,I get to see "calculate" mentioned on the bottom left. The problem is when this "calculate" i...
-
Excel/VBA 2010 Continue with Macro [Solved/Closed]
Hello, Just a quick question I've got a Macro that runs perfectly except there are two times while it runs where it stops and asks you to click Ok...
-
EXCEL to EXCEL mailmerge, is it possible? [Closed]
I have a list of names, with their room numbers, acct. numbers, birthdays, and addresses in excel (roster.xls). Every week, I had to print several ...
-
VBa Code Did't Open Workbook [Closed]
Hello, I'm having a major headache in figuring out why the VBA code which I'm applying at my office computer seems to work perfectly but fail to w...
-
VBA Conditional Formatting Excel 03 [Solved/Closed]
Hello, How can i apply a conditional format on a certain cell but with the condition in a different cell. F.e. if a cell in range C1:D5 (f.e. C...
