Excel Forum
-
Macros for making a graph in different tabs. [Closed]
Hello, Hey Experts, I recently tried to use macros to make graphs. I have more than 15 tabs on my excel. Each of them have a similar data with ...
-
Macro/Formula in Excel [Closed]
Hello, I want to search for a word in the format eg.ABC-2012-123( where only ABC is fixed and the other numbers after hyphen keeps changing) in ea...
-
VBA - Search engine help [Closed]
Hi guys, These threads are really helpful but i still cant get mine to work. I have created a knowlege base on excel for all the fixes on my serv...
-
getting data from another worksheet [Closed]
Hello, I am having 2 worksheets in a workbook sheet1 consists of a data like this: Country name Site engineer Name Contact Details Ben...
-
Copy/Paste Macro for Excel 2011 for Mac [Closed]
Hello, I am in of help! I've tried searching the forum for a code that will work but sadly i've not found one. I am try to create/code a macro or b...
-
Excel macro to create files based on column [Closed]
Hello, I want to create a macro which creates files based on contents in column AJ. and I want the macro to copy the data from original sheet...
-
macro to search, find, copy rows and replace [Closed]
Hello, I am trying to create a macro to search for a number from one workbook in another workbook, and then either copy the entire row or copy the ...
-
Copy particular columns to next sheet [Closed]
Dear friends, Plz help me to do the below requirement Current situation sheet one PTS invoice# status amount proc.date 1234...
-
find data in another spreadsheet [Closed]
Hello, I need my stock checker to pick up data from our suppliers spreadsheet which they change daily. So what i need for example is: To mat...
-
VBA - Transferring select Data to new sheet [Solved/Closed]
Hey there, I'm trying to create a macro for an Excel 2003 spreadsheet that will take a record (a row (or rows)) that I've already selected into a new ...
-
Excel: How to create a complex date formula [Closed]
Hello, I need to create a date formula that only includes weekdays. I want to have a formula that does (=previous date+1) for 5 boxes and then...
-
Excel Doubt [Closed]
Hello, I am using excel 2003 and pl help me to solve the below issue I want to compare two cells from one worksheet to other to write value ...
-
Sum using Macro? [Closed]
Hello, So sorry for my continuing inability to get my head around macros! I'm trying to workout a new spreadsheet and would really appreciate any...
-
Excel Formula: copy data and add "0000" [Closed]
Hello, how do I copy data from worksheet 1 into worksheet 2 (i know how to do this part), AND 1) delete the 4 digits at the end (i know how to do...
-
Conditional copy of row to other worksheet [Closed]
Hello, I have a 7 sheet workbook which contains a part number in column A of each sheet with details following it. I am trying to write a VBA code...
-
Excel: Empty cell in 2007 [Closed]
Hello, When presenting raw of data into a chart there is an option to present empty gaps as zero, gaps or connect the dots. none of teh option is wor...
-
paste data into alternate blank cells [Closed]
Hello, in using Microsoft Excel 2007, I'd like to paste data from one column into a another column that has some data in it along with some blanks ...
-
VBA dynamic paste after values [Closed]
Hello, Iam trying to do more or less a copy paste Macro in excel. The date comes out in the following format: Entity-----Account1----Account2 ...
-
Macro To Create Worksheets & Add Dates [Closed]
Hello, I have a worksheet (Excel 2007) that has two master pages with data, Weekday, and Saturday. Every month the tab Weekday is copied and renam...
-
Macro to cross reference Workbooks [Closed]
Hi all, I am (VERY) new to macros, and I am trying to create one that searches the cell in Column D in workbook 2, cross references it by the same...
-
Need macro to copy the searched data [Closed]
Dear Friends, I am having a bug report. In that different developers will have a bug for each module. And each modules are in different sheet. ...
-
Macro to delete specific number of rows. [Closed]
Hello, i have a imported text file into exel and i want to delete some specific number of rows after specific number of row say i want to delete ...
-
Comparision of Excel data [Closed]
Hi, I am looking for comparing calues of sheet1 with sheet2 if the fileds in sheet1(coloumn A) is matching with filed in sheet2(coloumn A). If the ...
-
VBA code to conditionally copy the data [Solved/Closed]
Hello, need help! see I need a vba code that can copy data from sheet1(raw data) to sheet 2,sheet3 and so on is certain condition matches..exam...
-
Pull specific data from excel cell [Closed]
Hello, Is there a way to pull specific data from one cell and then put that data in multiple cells following the original cell? For example, her...
-
create a infopath sheet [Closed]
Hello, I want to make a file in infopath where we capture the service complains and generate the case id for different customer, every customer ha...
-
VBA Macro Help [Solved/Closed]
Hello, I have a report that I am using for a customer of mine that lists there kits in a matrix for me. Once in a while I find an error where a kit...
-
vba problem [Closed]
Hello, thanks foryour attention.infact I am working in a company where I have to enter the data on the daily basis.So sheet2 is changes.bu sheet o...
-
vba problem [Closed]
Hello, In sheet 2 ,I have these fields and in sheet1, I have these plus some more. Order # PO # Item # Description Lease Rate Rental Serial ...
-
Excel Conditional formatting [Closed]
Hello, I am working with a mid sized spreadsheet (around 500 rows) and Am trying to set the formatting so that if a date is earlier than today, it w...
-
Excel 2003 VBA-transferring selected data [Closed]
Hello, I want to create a macro that will take a record (a row (or rows)) that I've already selected into a new sheet (I'll call this spreadsheet ...
-
macro for copy data for only two same column [Closed]
Hello, i want macro for copy data for only two same column in all worksheets to one new worksheet in a workbook , column name like B or F . in all t...
-
split mutiple columns in sets of 40 [Solved/Closed]
Hello, I have data in 3 columns A,B,C and it goes to 1000 rows, I want it to be splitted in sets of 40 each . Like first 40 then next 40 and so on...
-
Copy cell and its formating in Excel [Closed]
Hello, One thing that I have not been able to figure out is how to Duplicate a cell and its current Highlighted color. For example: Shee...
-
Excel 2010 - copy filled in cells [Closed]
Hello, I have a Workbook that contains a number of worksheets related to estimating costs. On one worksheet I have a several sections that use dro...
-
excel 2010 date formula conditional question [Closed]
Hello, I have a date a visa was issued. The visa expires 1 year from that date. I wish to highlight the relevant column in Red to mark that is d...
-
copy data from one sheet to another [Closed]
Hello, Dear All, i am running a small business of mine and i want this working, let me tell you first all about it There are 100 people t...
-
Need help copying rows please [Closed]
Hello all, I'm using Excel 2007 and I'm having trouble figuring out a way to move complete rows from one workbook to another. Currently I am utili...
-
Checking if a worksheet exists [Closed]
Hello, I'm back again. I'm trying to determine if a worksheet exists in a workbook. If it does, I want to skip to the end of the code and do...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received