All files are located in different path
vba will be placed in a macro.xlsm
i have a file name 1.xls & 2.xls
match column I of 1.xls with column B of 2.xls
If column I of 1.xls matches with column B of 2.xls then do nothing &
if column I of 1.xls doesnt matches with column B of 2.xls then copy and
Hi All,
I would appreciate if anyone can help me on the following.
I have a spreadsheet where I collect stock prices on the first tab, with
stock names by the columns, and dates by the row. Daily I add one more line
at the bottom with new prices. So on tab1 I have 10 columns and endless
rows, a
>
>
>
> Hello Guys,
>
> kindly assist with VBA code to copy data from workbook A (PTRS) and paste
> the data in workbook B-Daily Trades (With workbook B possible closed).
>
> from the attached sheet, i want to copy data from PTRS workbook in PTRS
> worksheet and paste it in Daily Trades workbook
Copy and Paste Large data.
I have a question about using Macro to copy and paste large data to another
workbookI have data with 6000 rows running up to column AK. Is this a safe
approach? I am going to use this copied data to update 10 pivot tables
Below is the code that I am using.
Wor
Hello,
I use VBA in Excel 2003 and my problem is:
I have a sheet protected with some cells unprotected. If I protect sheet
manually, the operator can copy and paste unprotected cells.
If I protect sheet in a subroutine, the operator can copy but can't paste
unprotected cells.
Please find an at
If we have sample data on worksheet this will be more easy, but i'll try
to do without it.
Sub EnterData()
Dim Sh As Worksheet
Dim Src As Range
Set Sh = ActiveSheet
Set Src = Sh.Range("D2:D8")
Src.Copy
'Sheets("Register").
Sheets("Sheet1").Activate
Range(Range("
Hi,
Im chasing help. I have two spreadsheets in which someone will enter data
in one and it will copy over the data to the next speadsheet and then the
original data will be deleted to start again. I have done this so far that
the data transfers over but cannot get the data to clear once it ha
, 2013 8:55:00 AM
Subject: $$Excel-Macros$$ copy and paste filtered data to new spreadsheet
Hi,
When I copy formatted data that has been filtered to exclude some data and past
it to a new spreadsheet the size of the new workbook is much bigger eg
20,000KB.
Original had lots of worksheets and
Hi,
When I copy formatted data that has been filtered to exclude some data and
past it to a new spreadsheet the size of the new workbook is much bigger eg
20,000KB. Original had lots of worksheets and formula but still was only
2,000KB.
Why is this and how can I reduce the size? I do which t
inal Message-
From: Eddie
Sent: Thursday, November 03, 2011 11:46 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)
This looks good but gettin a run time error 1004!
On Nov 3, 4:36 pm, "dguillett1" wrote:
Sub cc()
Sheets
:l6").Copy cells(activecell.row,”f”)
> > > > > end sub
>
> > > > > Don Guillett
> > > > > SalesAid Software
> > > > > dguille...@gmail.com
>
> > > > > From: Sam Mathai Chacko
> > > > > Sent: Thursd
m, "dguillett1" wrote:
> > > > Sub cc()
> > > >Sheets("start").Range("h6:l6").Copy cells(activecell.row,”f”)
> > > > end sub
> >
> > > > Don Guillett
> > > > SalesAid Software
> > > > dguill
Range("h6:l6").Copy cells(activecell.row,”f”)
> > > end sub
>
> > > Don Guillett
> > > SalesAid Software
> > > dguille...@gmail.com
>
> > > From: Sam Mathai Chacko
> > > Sent: Thursday, November 03, 2011 11:18 A
m: Sam Mathai Chacko
> > Sent: Thursday, November 03, 2011 11:18 AM
> > To: excel-macros@googlegroups.com
> > Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)
> >
> > Sub PasteStat()
> >
> >Sheets("start").Range("h6:
gt; From: Sam Mathai Chacko
> Sent: Thursday, November 03, 2011 11:18 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)
>
> Sub PasteStat()
>
> Sheets("start").Range("h6:l6").Copy Sheets("
Thanks,
However, can you automate this so I dont have to edit the sheet number
everytime i use a differnt sheet?
On Nov 3, 4:17 pm, ashish koul wrote:
> replace sheet1 with ur Sheet30 in the ur code like
>
> Sheets("Sheet30").Select
>
>
>
>
>
> On Thu, Nov 3, 2011 at 9:25 PM, Eddie wrote:
>
>
Sub cc()
Sheets("start").Range("h6:l6").Copy cells(activecell.row,”f”)
end sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Thursday, November 03, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy a
Sub PasteStat()
Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
Selection.Row)
End Sub
Regards,
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 9:25 PM, Eddie wrote:
>
> Sub PasteStat()
>
>Sheets("start").Select
>Range("h6:l6").Select
>Selection.Copy
>Sheets("She
replace sheet1 with ur Sheet30 in the ur code like
Sheets("Sheet30").Select
On Thu, Nov 3, 2011 at 9:25 PM, Eddie wrote:
>
> Sub PasteStat()
>
>Sheets("start").Select
>Range("h6:l6").Select
>Selection.Copy
>Sheets("Sheet1").Select
>Range("f" & Selection.Row).Select
>A
Sub PasteStat()
Sheets("start").Select
Range("h6:l6").Select
Selection.Copy
Sheets("Sheet1").Select
Range("f" & Selection.Row).Select
ActiveSheet.Paste
End Sub
Hi,
How do I edit the above so that the selected sheet (in this case
"Sheet1") is the active sheet. I.e. if i
y, August 22, 2011 4:40 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Copy and paste
>
> Hi everyone!!
> Just wondering if this is possiblecreate a command that will copy
> the data I have selected and paste it to another worksheet. Also, I
> need the copied
See if it helps :
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of bom
Sent: Monday, August 22, 2011 4:40 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Copy and paste
Hi everyone!!
Just wondering if this is possible
Hi everyone!!
Just wondering if this is possiblecreate a command that will copy
the data I have selected and paste it to another worksheet. Also, I
need the copied data to be placed in the next blank row in the other
worksheet. Now here is where I can not find my answer. I need the
"selected" d
acros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of Andrew
> Sent: Monday, July 11, 2011 4:28 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Copy and paste between sheets problem?
>
> I was curious if anyone had a solution for my problem?
>
&
Use Application.CutCopyMode=False after Copy the Range
Please attach your file.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Andrew
Sent: Monday, July 11, 2011 4:28 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Copy
I was curious if anyone had a solution for my problem?
Here is some code i start with:
Sheets("A").Select
Range("A2").Select
This is where i select my starting point
On this row i used the macro recorder and i copied 4 columns from
worksheet A to worksheeet B
But the problem is that when i am
Hi Bob
it would be great if you could provide sample file, you will get solution
from other members as well
On Sun, May 1, 2011 at 5:32 PM, Bob wrote:
> Saying that the copy and paste area are not the same size. But I
> changed to same size and still will not work. Thanks for your help!!
> Gett
Saying that the copy and paste area are not the same size. But I
changed to same size and still will not work. Thanks for your help!!
Getting an error here:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=FalseOn May 1, 1:49 am, Mahesh parab
Hi Bob
Try
Sub copydata()
'Copy contents from Sheet2 Columns A & B
Sheets("Sheet2").Select
Range("B1").End(xlDown).Select
Temp1 = ActiveCell.Address
Range("A1" & ":" & Temp1).Select
Selection.Copy
'Paste contents on next available blank row on Sheet1 in Columns A & B
Sheets("Sheet1").Select
Range(
I'd like some help in Copying and Pasting in different worksheets.
Copy contents from Sheet2 Columns A & B
Paste contents on next available blank row on Sheet1 in Columns A & B
Thanks in advance!
--
--
Some important
I have two sheets, sheet1 and sheet2. Sheet1 is a report template,
Sheet2 has some cell references at the top to the SQL queries in the
bottom.
Here's what I have in my vba code.
Step 1 - Application.RefreshAll
Step 2 - Copy referenced cell values on Sheet2
Step 3 - Paste on Sheet1
My problem:
I am currently creating an excel based estimating software and have
hit a brick wall.
Two-Fold Problem:
My current database format utilizes drop down items under each
estimate sub-item.
First I want to be able to, once an item is selected, have another
line automatically copy and paste the origi
32 matches
Mail list logo