VBA Coding

Posts
1
Registration date
Monday September 9, 2019
Status
Member
Last seen
September 9, 2019
-
I had a file with 2 sheets say 1,2. From 1st sheet I want to copy one by one cells of A column whose value is OK in C column and paste it in C1 of sheet 2.

In the output I want a button in sheet 3 which when I click give the complete list which are searched in sheet 2 along with row 7 of sheet 2 in front of every item

In easy term it select a cell A1 from sheet 1 ,check whether its valid or invalid in column C of same sheet.If invalid goes to next and if valid goes further i.e. copy it in C1 of sheet 2 and select the 7th row as o/p.This loop should continue until all cells of column A are done.
See more 

1 reply

Posts
2570
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2019
379
0
Thank you
Hi Chauhanskapil,

What I understand is that you want to copy Sheet1 column A, when Sheet1 column C is "OK", to Sheet2 column C.

What I don't understand is what the button on Sheet3 is supposed to do?

This line also confuses me:
"copy it in C1 of sheet 2 and select the 7th row as o/p".
C1 of Sheet2 is the output, what about the 7th row?
Won't the 7th row be affected when column C gets filled with data?
Do you mean the entire 7th row, or just a few columns of the 7th row?

Consider posting some screenshots (always be careful with sensitive data) to help clarify.

Best regards,
Trowa

Respond to TrowaD