Excel 2010 :: Rename New Worksheet With Data That Is In Cell

Nov 5, 2013

I have a workbook that filters the data on the worksheet "Reports" this then adds new worksheets and copies and pastes the relevant data that has been sorted, this is done by the name in column "B".

What I need is to rename the new worksheets with the data that is in cell "B2" of the new sheets.

Using excel 2010.

View 4 Replies


ADVERTISEMENT

Excel 2010 :: Rename Tab To Equal Cell?

Oct 20, 2012

find a code which will rename each tab to equal the content of cell - A2 for example.

This is in a workbook containing one sheet for each week of the year, thus starting 04/01/2013 ( I am in England so 4th January 2013.)

I have found many replies, but all seem to produce errors. As they are several years old, could this be because I am using Office 2010?

View 2 Replies View Related

Excel 2010 :: Copy Data From One Cell Based On Color Of Another Cell To Different Worksheet

Jan 30, 2014

I have an Excel 2010 spreadsheet consisting of many worksheets (20 or so). Each of these worksheets contain detail level data regarding different projects. One of the columns in these worksheets is the 'Status' column (column F). There is conditional formatting on this column where if the text is 'G' then change background to a green color, 'Y'=yellow, 'R'=Red and 'U'=Grey.

The first worksheet is a summary sheet that I would like to pull information from each of the detail worksheet's columns B, D, E, G and H if the status column (Column F) is 'R' or 'Y'.

The number of rows in the detail worksheet can change each week (as few as 0 and as many as 100)

View 2 Replies View Related

Excel 2007 :: Email Current Worksheet And Rename It From Reference To A Cell

Oct 25, 2012

I have the need to email the current worksheet in Excel 2007, which I have been able to do with the following ...

Sub SendTab()
'Declare and initialize your variables, and turn off screen updating.
Dim wks As Worksheet
Application.ScreenUpdating = False
Set wks = ActiveSheet

[Code] .......

Is there a way I can also get it to also rename the sheet from the default "Book1" to the information in a referenced cell.

View 7 Replies View Related

Excel 2010 :: Copy File / Rename And Move To New Folder

Jan 15, 2013

I am trying to copy a file, rename it, and save it to a new folder. I keep getting a "Compile Error ; Syntax Error" at line FileCopy (ImagePath & oldName, NewPath & newName). I am using Excel 2010.

FileCopy (ImagePath & oldName, NewPath & newName)Sub RenameFiles()
'Renames file based on "sheet 1" - Column 1 Old file name - Column 2 New file name
Dim oldName As String
Dim myfile As String
Dim newName As String
Dim ImagePath As String
Dim NewPath As String

[code]....

View 5 Replies View Related

Excel 2010 :: Rename Files In Multiple Folders And Copy To New Folder

Sep 22, 2013

For the last year I have been downloading cash register X1 and Z1 files onto an SD card. Each night's files (X1 & Z1) are stored in a new folder with the naming convention "RP + [DATE]", (EX: RP120910, [YYMMDD]). I have 265 folders! I need to go through each folder, select the Z1 file (I don't care about the X1, X2 or Z2 files) and rename each with the following naming convention: "Z1 + folder_name + .xls". For Example: Folder RP120910 contains the Z1 file named "Z1_T1729.ECR". After renaming, the file should be "Z1RP120910.xls". As the VBA code loops through each subfolder, selecting and renaming the Z1 files, I would like the new files to be placed into a new folder named "Z1Files". Note: All subfolders are currently in a directory named "RegisterFiles". I am using Excel 2010.

View 3 Replies View Related

Excel 2010 :: Referencing Cells Containing Dynamic Data In Another Worksheet?

Jun 15, 2012

I have a a spreadsheet that pulls user information from our corporate address book. I would then like to copy that data to another worksheet for additional data scrubbing. The problem I am facing is that, I can get the reference to work the first time but if I pull new data down, the destination spreadsheet now shows #REF!

I've tried using the below formulas but they all wind up the same way. ' Results' is the name of the spreadsheet I am making the reference to which has the dynamic data in it.

=Results!#REF!
=INDIRECT("Results!$B3")
=indirect (cell("results",B3)

View 1 Replies View Related

Excel 2010 :: Merging Multiple Worksheets Into One All Data Worksheet?

May 29, 2013

I know there are many ways to create an "All Data" worksheet. Copy & Paste is the most obvious or pasting named ranges into the new worksheet. I have a workbook with 48 tabs with up to 1000 rows of data per sheet. I need to merge each tab into one main "All Data" worksheet.

How to combine these 48 sheets in an easier way than the two options I already know (Copy/Past or Paste Named Range). Any Add-In's to Excel that can possibly do this? I am using Excel 2010.

How to make this "All Data" worksheet combining data from each sheet of the 48 tabs would be most useful.

View 2 Replies View Related

Excel 2010 :: Macro To Delete Last Line Of Data In Each Worksheet In Workbook?

Apr 24, 2014

I'm trying to create a macro that will look at each worksheet in a workbook and then delete the last line of data on each worksheet. The last row can vary on each worksheet. This is what I have come up with but it is not working. I am on Excel 2010 and Windows 7.

Sub Macro1()
Macro1 Macro
Dim ws As Worksheet

[Code]....

View 2 Replies View Related

Rename Worksheet With Cell Value

Jun 26, 2012

I need to rename the sheet5 with the value in E3 of Sheet2.

View 1 Replies View Related

Macro That Will Rename A Worksheet Based On The Value Of The Cell?

Jul 28, 2008

Is it possible to write a macro that will rename a worksheet based on the value of the cell?

For instance, if cell a1 has the value Test, the worksheet should be named Test. If I change the value of the cell to say Test 1, the worksheet should automatically rename itself to Test 1.

View 9 Replies View Related

Rename Worksheet Cell Value In Another Worksheet

Aug 29, 2011

I have renamed worksheets according to a cell value in the same worksheet, but now I need to rename the worksheet according to a cell value in another worksheet.

Here is the code I tried:

Code:

Private Sub Worksheet_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Sheets("Set-Up Page").Range("B2").Value "" Then
'rename the worksheet to the contents of cell B2
Sh.Name = Sheets("Set-up Page").Range("B2").Value
End If

End Sub

I have pasted that code into the worksheet that needs to be renamed, but it doesn't work. I have also tried:

Code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = Sheets("Set-up Page").Range("B2") Then Sh.Name = Target
End Sub

I like the first one because it checks for a blank value. There will be blank values depending on how many worksheets each teacher needs, so it will just rename the ones that have values filled in. Each worksheet will have the code referencing to a different cell on the Set-Up Page worksheet.

View 9 Replies View Related

Macro To Create And Rename Multiple Worksheet And Then Placing Relevant Data

Feb 24, 2014

I want to find a way to create multiple worksheets and matching data to be placed on appropriate sheets.

Here are more details (Please check the attached sheet screenshot as well):

Excel_Macro_Requirement.jpg

In a workbook, there is a "Master-Sheet". This master sheet contains 8 columns.

I want to create as many new worksheets after master sheet as the values are there in column B (Column 2 i.e. Ad Group). In above attached screenshot, there are 8 values (B2:B9 or A-H). So, I would like to create 8 new worksheets after the master sheet. Also, I want to rename them based on their value from Ad Group column.

Each newly created worksheet should have same columns as the master sheet . Same 8 columns with their name intact.

Finally, I want all matching data of the Ad Group values to be placed on their respective newly created worksheet. For example, worksheet A should have A2:H2 data. Worksheet B should have A3:H3 data, and so on.

Please note that same ad group may have more than one row data. But I don't want to create multiple worksheet of same name ad group. The worksheet should be just one, but all matching data should be placed in that one sheet.

I know it is a bit complex task, but I am sure there would be a way to perform this automatically - probably a macro.

View 1 Replies View Related

Copy Worksheet, Rename As Cell Value & Sort All Sheets

Oct 1, 2009

I am working with a workbook that has data automatically entered each time a new child is enrolled to the program. The child's data is automatically entered to the sheet named "Intake". What I need to do now is rename that sheet using the child's name as the sheet name, but also keep the sheet named "Intake" for the next entry. I would then like to sort the sheets alphabetically but leaving the "Intake" sheet either as the first sheet or the last sheet. I have attached an example of the workbook I am working with.

View 6 Replies View Related

Excel 2010 :: How To Filter / Sort Data Based On Partial Match Of Data In Cell

Apr 16, 2013

I am using Excel 2010. I am a novice user.

I have a lot of data to filter / sort. I want to initially to create a filter for a column of data - which has the format similar to hierarchical paths to files. The data is a mix of text/numbers. e.g.

pathA/path_X/path_Y/path_Z/lso0_rxs_reg_254__5_0/d
pathA/path_X/path_Y/path_Z/lso0_rxs_reg_253__5_0/d
pathA/path_123/path_456/data_out_reg_17_0/d
pathA/path_123/path_456/data_out_reg_0_0/d
pathA/path_X/path_Y/path_Z/lso0_rxs_reg_255__5_0/d

[Code] .........

Doing an alphabetical sort of this date would return the following order. As you can see while each strings in unique - there are many instances where they are simialr - if you ignore the unique numeric values at the end of the string.

pathA/path_123/path_456/data_out_reg_0_0/d
pathA/path_123/path_456/data_out_reg_17_0/d
pathA/path_123/path_456/data_out_reg_4_0/d
pathA/path_X/path_Y/path_Z/lso0_rxs_reg_230__6_0/d

[Code] ......

So what I want to do is to create a filter for the strings - but ignoring the numeric bits at the end i.e.

reg_[0-9]+_+[0-9]+/d

The strings are obviiously of varying length and the number of hierarchical paths is different, so I can't split string on "/".

Similarly folder paths names can contain "_" so can't split string on this either.

As I don't know how many "/" or "-" instances there will be in the string I don't believe I can use the find function. Also as the amount of number will be different i don't think I can use =right(a1,X) either.

I may be able to search for the pattern above - as this is probabay unique - so maybe it's something like the following pseudo code:

Function GetString(txt As String) As String
With CreateObject("VBScript.RegExp")
.Pattern = "reg_d+(_)+d+//d"
GetString = .execute(txt)(0)
End With
End Function

If I do require VBA code - how do I then use this for creating a column filter? Or will I have to extract the filtered data first from the column (and its associated row data) into another worksheet to use?

Once I have the filter in place I want to create tables using the filtered data - so for example each column value above has a lot of associated data values in each row e.g

26 pathA/path_123/path_456/data_out_reg_0_0/d
32 pathA/path_123/path_456/data_out_reg_17_0/d
8 pathA/path_123/path_456/data_out_reg_4_0/d

So my table would show the name "data_out_reg" and the range of values 8-32

View 1 Replies View Related

Automated Worksheet Copy, Rename Based On Cell Results

Jul 29, 2009

I am building a workbook. The data we are tracking is all in one xml file, which i have mapped to 3 different worksheets(customers, invoices, inventory). On the customers and inventory sheet I have an interface for creating a new customer/product/invoice. I used the macro recorder to make the macro's to do these three things, but could use help on a couple of other functions as I don't actually know VBA. I need to be able to automate editing of existing records by having a button to press on the each sheet that will open an input box that asks the user which invoice number, customer number or product number he would like to edit, then copy that record to the interface for editing, then another macro to replace the existing data with the newly edited data. It would also be wonderful if when creating or editing an invoice it could create a copy of the interface worksheet and rename it as the invoice number. The first row of each datasheet is blank, and each of the interfaces have formula's for importing the information copied to row 1 from the data tables. the second row of each datasheet contains formulas for importing data from the interface. Any help would be terrific...I know you guys are excel gods and I will forever be in your debt if you can help me out....thanks in advance, I'll be studying my butt off until I figure this out

View 11 Replies View Related

Excel 2010 :: Cut Out Half Of Data From A Cell

Sep 11, 2013

Is there a way in excel 2010 to cut out half of the data in a cell .. to make the top four in example to look like the bottom four?

1986 Jun- 9 to Jun-13

1986 Jun- 2 to Jun- 6

1986 May-26 to May-30

1986 May-19 to May-23

1986 May-12

1986 May- 5

1986 Apr-28

1986 Apr-21

View 5 Replies View Related

Excel 2010 :: Repeat Cell Data Based On Another Cell Column Dragging Down

Apr 24, 2014

Formula that will repeat a cell number as it drags down and as soon as the number changes. I am using helper column that shows the cell number. I need to drag this down about 1000 rows.

Excel 2010
A
B
C
1
Helper Column
Desired Result

[Code].....

View 6 Replies View Related

Excel 2010 :: Locating One Cell Data In Text Of Adjacent Cell?

Jul 1, 2013

I am using Excel 2010.

In my worksheet I have 'Column A' and 'Column B', In 'Column A' are product I.D. numbers. In 'Column B' is a text description of the product, whose I.D. number is in 'Column A,' and should also contain the I.D. number from 'Column A' somewhere in the midst of the descriptive text. However, some of these in 'Column B' do not.

I need to create a function that looks for the value in 'Column A' and determines whether or not it is present in the text of 'Column B'. Therefore, spitting the answer out in 'Column C' so that I can copy it down for 100,000 cells.

View 5 Replies View Related

Excel 2010 :: Formula To Show Data Of More Than 3 Cell?

Aug 7, 2014

(Excel 2010). I have 3 cell that contain data. What I need is to compare the 3 cell and return the data that has different value into 1 new cell.

I have attach an example : test.xlsx‎

View 3 Replies View Related

Excel 2010 :: Auto Update Cell Data

Nov 1, 2011

I would like make a cell in a report auto update with the most recent data entered in another cell from an input table either in the form of a formula or code to ensure that the most recent data is recorded and reported.

View 3 Replies View Related

Excel 2010 :: VBA To Start Macro When Changing Data In A Cell

Jul 21, 2014

When a change is made in cell L11, cell N11 should be locked automatically for typing. This is true for the cells between L11:L25, and cells N11:N25.

I have been trying to come up with a code that will:

1 - start my macro when f.ex. L11 is > 0
2 - lock N11 when L11 is filled out
3 - unlock N11 when the input in L11 is deleted

This is my attempt so far to put together a code:

[Code] .....

I'm using Excel 2010.

View 1 Replies View Related

Excel 2010 :: Insert Row Data N Times Based On Cell Value

May 1, 2012

I have a sheet that contains the following columns:
Invoice, Document #, Date, PO #, Part #, Part Description, Quantity, Net Amount

Based on the quantity in the row I need to copy the row, and insert it n-1 times. So if the quantity is 5, I need to copy and insert the data below the original row 4 times for a total of 5 rows of data.

I plan on firing the macro with a button as the data will change month to month.

Using Windows 7 and Excel 2010

View 2 Replies View Related

Excel 2010 :: Pulling Cell Values Into URL When Using Get External Data From Web?

Feb 20, 2014

I am using Excel 2010. I am trying to make a spreadsheet where I can type in a date (02-19-2014), and pull in box scores from a basketball website. I have everything set up so that the date is parsed into (3) cells (02 19 and 2014) so that it can easily fit into the URL:

[URL]

As you can see, the month value in the URL is "02" the day value is "19" and the year value is "2014". What I want to be able to do is type in any date I want and return the box scores from that day in a new tab. I have everything done so that the new tab is automatically created and named, so my only issue is that I can't figure out how to input the day, month and year values automatically into the code for the Get External Data pull:

Code:
'Import from www.basketball-reference.com
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.basketball-reference.com/friv/dailyleaders.cgi?month=02&day=19&year=2014" _
, Destination:=Range("$A$1"))
.Name = "dailyleaders.cgi?month=02&day=19&year=2014"

View 2 Replies View Related

Excel 2010 :: Importing Data Into Database - Cell Formatting

Mar 19, 2014

I'm importing data from Excel 2010 into a database.

I'm joining to 2 cells into one. A1 = 12 Rushwood Street and B1 = London. So C1 = 12 Rushwood Street London

I need C1 to look like this:

12 Rushwood Street
London

I tried wrap text but when I import it comes out as one line in the database.

View 3 Replies View Related

Rename Excel Sheet Based On Cell Values?

Aug 17, 2014

I am having trouble creating a macro that renames all excel sheets using cells on Sheet1.

See attached, I want to rename all excel sheets (renamed as "1", "2", "3"....."50") as "9999", "10000", "10001"..."10045", found in Sheet1, renamed as "Base". I will change the cell values everyday (range Base!A5 to Base!50) - and will rename all the sheets again.

Before: before.jpg

After: after.jpg

View 2 Replies View Related

Excel 2010 :: Prevent Change In Cell Format By Pasting Data?

Jul 19, 2014

I'm using Excel 2010. Is there any solution which cover requirements given below.

1) I've converted a range in to table format (using Format as Table)

2) Need to Prevent pasting on data validation cell.

3) Need to Prevent change in cell format after pasting data (other than data validation cells as mentioned above) from same workbook or other workbook

4) Need to insert row in the table as per requirement.

View 3 Replies View Related

Excel 2010 :: Data Validation - Restrict Value User Can Enter Into A Cell

Oct 2, 2012

I'm using Excel 2010, and I need to restrict the value the user can enter into a cell (E9).

In cell E3 is the screen width (pixels). eg 6024
In cell E5 is the preferred width of a window. eg 450

The user, in cell E9, enters an x coordinate for which they prefer the top left corner of the window whose width is specified in E5.

If the value that the user enters in E9, added to the width entered in E5, exceeds the value of E3, (if E9+E5 > E3) then the value should be disregarded (window will be off right of screen) and the user re-enter.

I'm not familiar with the use of data validation, so I'm uncertain as to how to use it in this circumstance.

View 3 Replies View Related

Excel 2010 :: Search And If Found Insert Data From Cell To The Left

Jan 17, 2013

I have two sheets with data. I wont excel to look for a value in colum A in sheet 2 the value to look for is defined in colum a in shet 1. If value is found it should insert in sheet one the value that is in the cell next to the found value. The data is not sorted. I have attempted and failed with using different functions.

View 1 Replies View Related

Excel 2010 :: Value To Cell Based On Horizontal And Vertical Data On Matrix

Jul 30, 2013

I have chart like below. In empty cells I want either 1 or 0 (1 if software is installed and 0 if not).

Excel
Outlook
Powerpoint
Word

Computer1

Computer2

Computer3

Computer4

Computer5

Data of computers and their software are like this:

Computer1
Word

Computer1
Excel

Computer1
Powerpoint

Computer1
Outlook

Computer2
Outlook

Computer2
Excel

Computer3
Outlook

Computer4
Outlook

Computer4
Excel

Computer4
Word

Computer5
Outlook

So called Matrix Lookup was very close, but it finds data FROM Matrix (aka that first table). Is it possible at all?

Excel and Windows version:
Excel 2010 SP1
Windows 7

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved