I am looking for VBA or a formulat that basically if D3=Connect then copy the value in B3 to the next open cell in column D of Sheet xxxx starting on row 3.
I am looking for VBA or a formulat that basically if D3=Connect then copy the value in B3 to the next open cell in column D of Sheet xxxx starting on row 3.
MaybePlease Login or Register to view this content.
will this paste to a separate sheet? I only ask cuz i dont' see where in the code it goes to another sheet. but i am new and ignorant so i am prob wrong.
Here
Please Login or Register to view this content.
When I enter the code it highlits the word worksheet and sub or function not defined.
change xxxx to your worksheet name
I did that. also will this work on multiple rows?
My bad. I just wrote the code without testing. There was a typo; it should be worksheets( not worksheet(
Please Login or Register to view this content.
Thanks alot. I really appreciate it. now I am getting a type mismatch error?
Can you post your file?
I would but I don't now how to compress it so its small enough.
How about a sample file?
Furnace Deck Passdown Rev K (Testing)120.xlsm
here you go
You were using a range. If you change the range to just individual cell reference, the error disappears.
change your code toPlease Login or Register to view this content.
A-SHIFT MONTHLY SAFE CARD COUNT.xlsmok its working now sort of. I need it to work for all the cells in range c3-c20 and the current code only returns the value of B3 in the T LINE HEAT sheet.
is there a way to make it work within a range?
Does anyone know how to make this work within a range
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks