Putting correct values in cells

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have a document that has 2 worksheets. i want to pull
information from one to the other e.g. i want to pull the
first record that has "cdt" as a reference into a
specific cell on the read worksheet. If cdt is not in the
information worksheet then no record will be shown

Thanks

Nick
 
set rng = somerangeonsheet1.find("cdt")
if not rng is nothing then
rng.entirerow.copy Destination:= _
somespecificrangeinsheet2incolumnA
End if
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill in data that is not empty 1
Sheet name=Cell value 2
mving select data (var # of cells) frm a range to another workshee 1
Selecting worksheet and ranges within sheet to run macro on 3
making a worksheet & certain ranges within a variable 3
How to reference a cell from anther workbook without opening it 0
Extracting for calculations 3
Arrays and scattered cell values or another way? 16

Back
Top