Question description:
This user has given permission to use the problem statement for this
blog.
I need to be able to automatically move certain cells if a specific criteria is met in a cell.
Solved by X. C. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
26/07/2018 - 04:13
Hi...
User
26/07/2018 - 04:13
Hello
User
26/07/2018 - 04:13
Hello
Excelchat Expert
26/07/2018 - 04:13
can you let me know the condition under which the cell content needs to be moved?
Excelchat Expert
26/07/2018 - 04:14
also if you have a sample data it will be easy for me to build a formula on
User
26/07/2018 - 04:14
If a specific word is mentioned in a row then certain cells in rows between columns 1-20
User
26/07/2018 - 04:16
So, this is basically what the spreadsheet consists of. If the auction column says smart I need it to move the stock #, last 8 of vin, year, make, model, and BN to a new sheet
Excelchat Expert
26/07/2018 - 04:18
which of these columns will might have unique values...
User
26/07/2018 - 04:18
On my sheet is column F, but on here it will be the auction column
User
26/07/2018 - 04:18
They will all have unique values, but I need for them to move based on the auction column.
Excelchat Expert
26/07/2018 - 04:19
ok.. so i will build a solution to look for the word "Smart" in column A
Excelchat Expert
26/07/2018 - 04:20
if it matches.. then data matching to that row will be copied to the new sheet...
Excelchat Expert
26/07/2018 - 04:20
give me few mins to build this
User
26/07/2018 - 04:20
OkY
User
26/07/2018 - 04:20
okAY
Excelchat Expert
26/07/2018 - 04:21
will the column A have only one WORD.. or it could have multiple words and Smart is inbetween those words
User
26/07/2018 - 04:21
No, only one word in the column
User
26/07/2018 - 04:21
It's a drop down box
Excelchat Expert
26/07/2018 - 04:22
awesome.. thx.. :)
Excelchat Expert
26/07/2018 - 04:31
PLease check the updated formula in sheet "Smart Auction"
[Uploaded an Excel file]
User
26/07/2018 - 04:33
Perfect, and this will work for how many rows?
Excelchat Expert
26/07/2018 - 04:33
for now the formula is for 2000 rows in Main_Auction
User
26/07/2018 - 04:34
That's perfect. I usually delete certain rows after I'm done with them so this will work great.
User
26/07/2018 - 04:34
Thank you!
Excelchat Expert
26/07/2018 - 04:34
:)
Excelchat Expert
26/07/2018 - 04:34
I have marked the session as done..
Excelchat Expert
26/07/2018 - 04:35
please close the session... and provide a feedback when you close
Excelchat Expert
26/07/2018 - 04:35
FYI... when you delete the rows.. from the main sheet...
Excelchat Expert
26/07/2018 - 04:36
the formula rows also will reduce by count..
Excelchat Expert
26/07/2018 - 04:36
so you would need to keep updating the formula..
User
26/07/2018 - 04:36
Okay. Is it a formula or vba?
Excelchat Expert
26/07/2018 - 04:36
its a formula
User
26/07/2018 - 04:40
Awesome. I have tried everything and researched for days. So, thank you!
Excelchat Expert
26/07/2018 - 04:41
You are welcome.. have a nice day..
User
26/07/2018 - 04:41
You too!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.