Hi guys Pls help me I really need your help guys!

J

jess_2010

New Member
Joined
Nov 4, 2013
Messages
2
xm4ggj.jpg


So above is my worksheet that I'm currently working at.


My problem is I want to automatically move D7:AM7 only (from the column of "Date arrived" to the very last "1X1" in the illustration) to sheet2 if A1 ("Status" column) would have a USED word in it. And after D7:AM7 would be cleared and be ready to enter for a new data. These proccess is applied to the succeeding cells (ex. D8:AM8, D9:AM9, D10:AM10 upto the very end)


I hope guys yo could help me with my problem, thank you in advance and have a blessed day!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
Welcome to MrExcel.

What do you mean by automatically? When you enter USED in a cell in column A or when you press a button?
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question
I need help with couple things clear data when you change validation and find monday night game teams
Replies
3
Views
273
TLS49
T
T
  • Question
Loop qnd improvement needed
Replies
5
Views
683
Michael M
Michael M
B
  • Question
3 three CASCADING DATA VALIDATION (CATEGORY, DESCRIPTION and MODEL) PLEASE HELP ! ! ! ! ! ! Thank you and GOD BLESS....
2
Replies
14
Views
7K
Brixton11
B
D
  • Question
Pivot table calculation help
Replies
2
Views
778
mrhartley
M
G
  • Question
Help with a counta and if statement
Replies
5
Views
8K
goldcat
G

Forum statistics

Threads
1,214,549
Messages
6,120,149
Members
448,948
Latest member
spamiki

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