Formula Or Code To Only Copy Text In Bold From Sheet1 To Sheet2

Jun 8, 2014

I want text that's in bold in column B in sheet 1 of my spreadsheet to copy over into column A in sheet 2 of my spreadsheet - is there a quick way of doing this using code or a formula?

View 3 Replies


ADVERTISEMENT

VBA Code To Copy Cell Contents In Column1 Sheet1 To Row1 Sheet2

Nov 27, 2013

I have data beginning in cell A6 and continues through cell A13 for this instance. I want data in cell A6 on sheet 1 to be copied to cell B1 in sheet 2; data in cell A7 sheet 1 to be copid to cell C1 sheet2 and so on till all of the data in the continuous range beginning in cell A6 of sheet 1 has been copied to row 1 beginning in cell B1 of sheet2. This seams relatively easy but below is my failed attempt at this.

Code:
Sheets("Data Request").Select
Dim DATAREQUEST As Long, TYPESRws As Range
TYPES = WorksheetFunction.Max(Range("A" & Rows.Count).End(xlUp).Row)
DATAREQUEST = Range("A6", "A" & TYPES).Rows.Count
Sheets("Data Retrieval").Select
For i = Range("B1", "1" & DATAREQUEST).Columns.Count To 1 Step -1
Sheets("Data Retrieval").Select
[B1] = i
ActiveCell.Offset(1, 0).Select
Next i

View 7 Replies View Related

Excel 2010 :: How To Populate Sheet2 From Sheet1 After Finding Matching Word On Sheet2 From List In Sheet1

Oct 4, 2013

I have 2 Worksheets in an Excel 2010 Workbook -

Sheet1
Column1: contains the word "dog"
Column2: contains the word "bark"

Sheet2
Column1: contains the sentence "I like dogs a lot."
Column2: is blank

What I need to do is search Sheet2/Column1 for the presence of "dog" and if it's present, populate the word "bark" in Sheet2/Column2 from Sheet1/Column2.

How can I do this?

View 4 Replies View Related

Compare Sheet1 With Sheet2 And Copy Unique Values In Sheet1

Aug 13, 2014

I am using the below code and it is not performing the operations of comparing and deleting the duplicate values from sheet1 and pasting unique values in sheet 1, p.s. Do not need values from sheet 2, just want to compare the sheet 1 with 2 and delete dups in sheet1.

[Code] .....

View 2 Replies View Related

Match Value In Sheet1 For Sheet2 And Copy To Sheet2?

Mar 4, 2014

I have a large file + 400 000 rows that has zip code but not city name in sheet2, in sheet1 I have a list of zip code and city name. I need to get the correct city name for the zip code in sheet2 by using the info from sheet1. I attached a file as an example how it looks. I do have lots of other data in the original files that I have removed. This is not doable manually by using filter, to many rows so I need a script to run it.

View 2 Replies View Related

Sheet1 Row Range Copy To Sheet2 Firs Blank Row In Same Range Paste As Text?

Mar 16, 2013

Trying to assign code to comm. button on User form to copy lets say:

(sheet1, rangeB2:B21) to (sheet2, first blank row rangeB2:B21) and paste it as text value one more question: what to be aware in case of sheets format (merged cells, hidden rows...)

View 4 Replies View Related

Code To Look At Sheet2 And Highlight Any Difference On Sheet1

Feb 15, 2013

I need a code that will look at each row on sheet 2 then highlight any cell that is different to the corresponding row/cell on sheet 1.

View 4 Replies View Related

Copy Array From Sheet1 To Sheet2?

Aug 16, 2013

I have a file. In sheet1, Array from row 2 to row 16 named "Vung1". array 2: row 20 -> 27 with name "Vung2".

I need: In sheet2, if I select "Vung1", Below with echo "Vung1" from sheet 1 (Keep format) and if I select "Vung2", it will echo "Vung2" from sheet1 (Keep format too).

I can't attack file. So I put a Gdocs link.

[URL]

View 1 Replies View Related

Copy Data From Sheet2.xls To Sheet1.xls?

Dec 3, 2007

I have:
- sheet1.xls, this is the source sheet.
column A = model numbers
- sheet2.xls, have the data that I need to copy to sheet1.xls
column C = product description text and in column D = product price
column G = product description text and in column H = product price

What I need to do is to write a Macro that:

open each row in column A in sheet1.xls and search in sheet2.xls in column C if it finds this text (model number) then it should copy row D (product price) and paste it to column E in the right row in sheet1.xls.
Also search in sheet2.xls in column G if it finds this text (model number) then it should copy row H (product price) and paste it to column E in the right row in sheet1.xls.

I hope please that you understand me.
And will be happy if someone could help me please to do that

View 9 Replies View Related

Copy Script From Sheet1 To Sheet2

Dec 14, 2009

i have a sheet called Template with this code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Row = 2 Then
If Target.Cells.Count 1 Then Exit Sub
boo = Target.Value
boobs = Target.Offset(-1, 0).Value
nocold = 4
WO_update_cust
End If
If Target.Column = 2 And Target.Row = 3 Then
If Target.Cells.Count 1 Then Exit Sub
boo = Target.Value
boobs = Target.Offset(-2, 0).Value
nocold = 5
WO_update_cust
End If
End Sub

i have another script than unhides a sheet and copys whats in the template to it.

Simply put i want to copy this script to it too.

i used a copy and add sheet method but i need to be able to do this in a shared workbook, hence the hidden sheets instead.

View 9 Replies View Related

Copy Specific Cells From Sheet2 To Sheet1

May 11, 2009

copy specific cells from Sheet2 to Sheet1. How would I change this macro if I wanted to copy all of Column B from Sheet2 to Sheet1

View 2 Replies View Related

VBA - Copy Input From Sheet1 To Sheet2 Without Overwriting Information

Apr 7, 2013

I have created a code in which the information from Sheet 1 copies to Sheet 2 correctly. Every time I input new information for my click event (ticket sales/amount received/change due) I want this information to be displayed in Sheet 2. However, every time I start a new submission, the information overwrites on the second Row so that only one submission is displayed. I need to create a history of all submissions from Sheet 1. Here is the code that I have to copy Sheet 1 to Sheet 2:

VB:
intRow = intRow + 1
If intRow = 1 Then
intRow = intRow + 1
End If

[Code] .....

View 2 Replies View Related

VB To Copy Cell Value In Sheet1 To Cells In Sheet2 If Criterion Met

Feb 27, 2014

This following is just an example:

In sheet1 I have 4 columns; Name, Age, *** and Job.

Sheet2 has three columns; Name, Age and Job.

What I need is VB that will check the *** column from Sheet1 and when it is Male, the Name, Age and Job fields from that row are copied into the cells in Sheet2.

View 10 Replies View Related

How Copy The Data From More Cell In Sheet1 To A Row On Sheet2 (others Sheet)

May 19, 2009

I want entry the data with different row and different cells, so when I click the button, the data on sheet1 is clear and copy to empty row on sheet2 and automatic create a border and automatic insert new row, so we can entry again and next. And I attached my sample Excel File with the description too.

View 10 Replies View Related

Compare And Copy New Rows From Sheet2 To Sheet1 If Conditions Met

Feb 21, 2014

I have a sheet of data (Sheet1 below) running into almost 1000 rows. Each month, I get an updated sheet (Sheet2) which has overlapping data with sheet1 (rows starting with N, O, P, Q), new data (rows starting with R, S) and data present in Sheet1 but not in Sheet2 (row starting with M in Sheet1). The columns "Item" and "Quantity" in sheet1 are populated by me and are blank in sheet2. The table below explains the structure.

Sheet1
Name
ID
Date
Item
Quantity

M
231
14/03/2001
egg
5

[Code] .......

It gets tedious to update Sheet2 every month. Is it possible to merge the 2 sheets into a Sheet3 (like below) if Name, ID, Date in each row is an exact match?

Sheet3
Name
ID
Date
Item
Quantity

M
231
14/03/2001
egg
5

[Code] ........

Further, it will make my job much easier, if it was possible to identify rows only present in Sheet1 and add a tag "absent in new" in a new columnidentify rows only present in Sheet2 and add a tag "new" in the new columnidentify rows with matching data in Name, ID, Date in Sheet1 and Sheet2 and add a tag "current" in the new column.

Something like the table below:

Sheet3 (Desirable)
Name
ID
Date
Item
Quantity
Comments

M
231
14/03/2001
egg
5
Absent in New

[Code] ...

View 2 Replies View Related

If Text Found In Sheet1 - Sheet2 Text Colour Will Be Red

Jun 29, 2014

Is there a formula in excel..

E.g., if text found in excel sheet 1, excel sheet 2 text colour will be red.

I try to use conditional formatting to rule, but cannot.

View 13 Replies View Related

Copy/past Rows From Sheet1 To Sheet2 But Only If - Automate Process?

Jun 24, 2009

I have two sheets: Sheet1 - linked from external file, new data coming daily.
Sheet2 - I need to copy/past Rows from Sheet1 to Sheet2 but only if B-cells are not empty. How can I automate the process?

View 2 Replies View Related

Macro - Copy To Sheet1 Data From Sheet2 Including Specifications

Mar 25, 2014

In Sheet1, i have a table like this:

Select Month
Actual Cost
Budget
Difference

[Code].....

I dont know how to do it here, but in Excel i have January (2columns) Febaruy (2columns) March tables. filled each table with its determinated data, and going down i have 3 more months, and so etc till i complete 12 tables one per month.

So now what i need is: That in Sheet1, where is Select Month be some kinda of drop down list, which allow me to pick the month i wanna see, and then when i pick. for example: April, then go to Sheet2, find the April table, and bringthe values to fill the table in Sheet1 , whatever option be, flirting, or copying just values, or filling the table. I really dont know what be easier.And then if i pick another month like October, do the same, etc.

View 1 Replies View Related

How To Use Formula For Transferring Data From Tab Sheet1 To Tab Sheet2

Dec 28, 2013

Date & Time JOB NO PENDING

12/23/13 2:14 PM SICD-B00xxx *

My question is, there are three cells named- Date & Time, Job No and Pending. When I tick(*) in Pending named cell, I need to copied automatically the data of Date & Time and Job No to Sheet 2 in the same cells from Sheet

1. which formula I can use and how?

Sheet 1 : Date & Time (O5), Job No (Q5) and Pending (S5)

Sheet 2 : The same as Sheet 1

When I give * in Sheet 1 S5, the other data should copied to Sheet 2 in O5 and Q5.

I want to use formula in sheet 1 S5 because I have already used a formula in sheet 1 O5, as

IF(Q5<>"",NOW(),O5),"")

View 3 Replies View Related

Code Adjustment To Copy And Paste Bold Text And Border?

Aug 13, 2014

Is it possible to modify the attached code so that it will copy bold text and border as shown in attachment sample1 and paste in sheet Shop. Currently the code just copy's and pastes without bold text and borders.

Sample1.PNG

View 4 Replies View Related

Copy Selected Cells From Sheet1 And Paste Them In Sheet2 Based On A Cell Value?

Dec 27, 2012

have two worksheets, "Entry form" and "Database" in my workbook. I am trying to put together a macro button to find the cell value D5(Entry form) in the column A:A (database), if found, copy selected cells (B5:D5,B7,B9) from entry form and paste in the adjacent cells of the row with the value in the database sheet.

VB:
'Match value D3 and replace data
Dim sht As Worksheet, outsht As Worksheet, r As Long
Dim rfoundCell As Range

[Code].....

View 9 Replies View Related

Open Another Excel File And Copy Data To Sheet2 While Button Upload Is In Sheet1?

Mar 27, 2014

how to copy data from one workbook to another workbook.

here's the process

1. Button upload is in book1 sheet 1
2. Copy data from book to book 1 sheet 2

Here's my code for starters.

[Code] ....

View 3 Replies View Related

Copy / Insert Row In Sheet3 If Cell Value In Sheet2 Matches Cell Value In Sheet1

Sep 17, 2013

I am working a project where I need to copy/insert a Row of data onto Sheet 3 if values from Sheet2 are located on Sheet1. Here is my code so far:

Option Explicit
Sub move_rows()
Dim ws As Worksheet
Dim ws1 As Worksheet

[Code].....

View 3 Replies View Related

Sheet1 With Two Columns Text Data - How To Get Data Automatically In Sheet2

Apr 14, 2014

I have two column (A and B) text data in worksheet1. If I type same text of column A (of worksheet1) in worksheet 2 column A, how can I retrieve data from worksheet 1 to 2 from same row.

View 1 Replies View Related

Copy Data From Cell In Last Row Sheet1 To Another Cell Sheet2

May 20, 2014

I need a macro which read out the last (in this file Pos. 4) or a user seleted Position (Position 2 or 1). The macro should read out the cells in this row and put the data into the defined cells in Sheet2.

in this case:

Data from B4[Sheet1] copy to B5[Sheet2]
Data from C4[Sheet1] copy to C7[Sheet2]
Data from D4[Sheet1] copy to E6[Sheet2]

The cells in Sheet2 are the same every time. Only the data (the row) in Sheet1 does change. I add more Position every week in Sheet1.

View 14 Replies View Related

Copy Data From Sheet1 Cell To Sheet2 Cell

Feb 4, 2014

I have a workbook with sheet1 and sheet2. Each sheet I am only dealing with columns A-D. The data in column A in both sheets is the unique identifier. The below macro I am using will take sheet1 (ColumnA) and compare to sheet2 (ColumnA). If the identifies are the same in both cells it will highlight it green.

What I need to add to the below macro is the ability to add a cell copy over. So sheet1 being my master, if sheet1 and sheet2 have a equal identifier in column A, the data from sheet1 B,C,D for that row will be copied over to sheet2 of its equal identifier sheet2 B,C,D.

I have attached a sample : Sample Copy Over.xlsx‎

View 4 Replies View Related

Formula To Separate Specific Data From Data List In Sheet1 Into Sheet2 / Sheet3

Jun 30, 2014

I have attached a sheet that has part of a data list, sheet called (Full Data) what i am trying to do is seperate the data into event locations into individual sheets.

The data ref will be column F which is the different event locations.

I thought the best way to try and do this was to create an if/ match formula using the sheet tab names as the if match, with the event locations in column F.

I have added two sheet tabs so you can see that i require the data for (Ain) to be put into the Ain sheet.

The data list in Full Data sheet will be continuously updated so i will need the range to be around 10,000 entries.

View 5 Replies View Related

VBA To Find Value From Sheet1 In Sheet2?

Jul 14, 2014

I want to find a value from Sheet1 in Sheet2. The code below has worked in the past, but this time Sheet2 has the value as a result of a function and it doesn't seem to recognize it. What do I need to change to make it work?

Sheet1 - the value is a number that has been typed in
Sheet2 - the number is the result of a function

[Code] .....

View 2 Replies View Related

Sheet1 & Sheet2 Transfer

Apr 7, 2009

Sheet1 and Sheet2 data transfer between Sheet1,
Sheet2 should be like. macro solution

View 2 Replies View Related

How To Transfer Certain Cells From Sheet1 To Sheet2

Dec 15, 2013

I am trying to do some kind of sorting?

if the first character of the cell is number or * then copy that cell(row i ) and the cell above(row i -1) to sheet2. I am not sure how to check the first character is *.

The idea is this:

[Code]] .....

View 7 Replies View Related







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