VBA-looking in every cell in row 1, specific values ​​of colum A

F

flaviu123

New Member
Joined
Aug 20, 2014
Messages
44
Hi everyone !
I need a code to look in every cell in row 1, with reference values ​​from columns A, and when found, copy value in the last row available in Sheet 2, column B.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
You must log in or register to reply here.

Similar threads

S
  • Question
Copying a row based on a integer in a cell
Replies
0
Views
451
Sheepy
S
C
  • Question
VBA data from closed workbook (link) only from last row
Replies
0
Views
554
ClaMuFasa
C
M
  • Question
Automatic sheets from list with content
Replies
1
Views
293
mvmonster
M
T
  • Solved
how to take only the first sheet on every workbook and sum specific cells
Replies
8
Views
1K
TheLSD
T
M
  • Question
VBA Copy and Paste certain Column rows into different sheet
Replies
0
Views
688
Manq5230
M

Forum statistics

Threads
1,202,975
Messages
6,052,868
Members
444,606
Latest member
rwmhr

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top