Forum Discussion
conditional copy excel
Good day, friends, I have a question, I receive data from the web, the data I receive is always in different order. I want to ask, can I copy by word? To explain through the example file, can I start...
Hello @ John_BloggsJohn_blk1405
Yes, this is workable in VBA or not VBA. I am shooting from the hip here but this is what I will do:
A) Find the cell with START in it.
B) Get the row of that cell
C) Find the cell with END in it
D) Get the row of that cell.
E) Copy from Row Start to Row End - 1
If you would like a VBA code example post a snipit of the data and I'll try and help.
Yes, this is workable in VBA or not VBA. I am shooting from the hip here but this is what I will do:
A) Find the cell with START in it.
B) Get the row of that cell
C) Find the cell with END in it
D) Get the row of that cell.
E) Copy from Row Start to Row End - 1
If you would like a VBA code example post a snipit of the data and I'll try and help.
The find function works in excel, but after a certain time it gives a splwow64 error, this error is caused by this function, because I tried it.
I want to copy the data between the cells that write start and stop and paste it into cell N1. It will copy including the place that says start-stop and paste it into cell N1 but this process has to be dynamic because the data is constantly changing.I added a picture(the green area will be copied and pasted into the red area)
