move

Good morning, I am hoping somebody could assist me with an formula i would like to write in order to do the following: If any row in column AL equals 1 Move that entire row to another sheet (Sheet 1 for this example.) As a side note; there may be large gaps between rows where column AL...

Hi, I need some help with creating a macro, that can move a open workbook to a new location and delete it from the original location. Is that even possible? regards, Hawjeen

Hi, I receive 20 to 25 emails a day from a common mail box daily to my Outlook 2016. I will then move those emails to a personal folder named "Daily email1" & "Daily email 2" based on email subject. I want this to be automated. Whenever I get those emails I want a button to run a code which...

Wise people of the forum... I am in need of a way to do tracking. We manufacturer many different products for many customers. Each product needs to move through several phase of assembly. We would like to move a product through assembly using dates. I have looked at Gnatt chartd but all I can...

Hello all, Could anyone help out with VBA code please? I have set of data in columns A, B and C(around 2000 rows in total). I would like to find all values which contain string "TOP01" or "TOP02" within column A, once string is found(there could be more than 50 records matching those keywords)...

Hi I've like to - copy sheet 9 in a workbook - move it to the front of the workbook - then copy and paste everything in that sheet as values Does anyone know how to do this, please? I know the code below will activate it then move it to the front. The methods I've seen online copy it to...

Hi I have 3 sheets named 1,2,3 and I am moving them around using the code below. sheet name "2" has the button which run the code. I want to do the move but keep going back to sheet("2"). I did it as below. How you would do it yourself? Is that good and efficient programming? Thank you so much...

Hi I have code to copy sheets into a new workbook but what I want to do is, move one and copy the other. I.e. Sheet1 > move Sheet2 > copy paste special (to remove formulas) then save the new workbook with file name as per cell A1 of Sheet2 However, I need the user to specify their own path...

Hello everyone. I need a code that will move specific rows to other rows in the same sheet based on a Cell Value. My spreadsheet has 4 sections (high risk, medium risk, low risk, completed). In column "J" of each section will be a number or a letter. Any number less than 3 is high risk, 3-7 is...

I have a line of code which works. Do... If .....then Exit Do When the code is satisfied the loop stops, but I want it to move on to a next step and I am not sure how to do this.

Hi, Not an advanced user of excel before so hoping someone can help out with this. I have a file with approx 1500 rows and approx 10 columns I need to automate to do the following: Select a row (row 1) duplicate it underneath as a new row (row 2) move to the next unique row (row 3) and...

Hello all, Good day. I have excel sheet in the below format. Excel 2013/2016ABC1Asset tagCIIM Asset IDStatus2E2902202118195Yes3E2900852118571Yes4E2913082119523Yes5E4190242127131No6E4524042128911YesSheet1Cell...

Assuming I have 10 sheets in a workbook, how do i move the 4th to 6th sheet to sheet 8 using vba.

Macro to move cursor to row A from any cell in that row

I am trying to move a sheet from activeworkbook to a file that is stored in a folder. Any help is greatly appreciated, I have attached the code that i am currently trying to use. I feel that i am over thinking this. Sub move_sheet() 'Move the active sheet to the end of named Workbook...

I'm looking to move rows to another sheet when a value in "H" is changed to "closed"

Greetings, So I've been adding hyperlinks in all my sheets to help expedite google searches w/ criteria located in various cells. He're's my handy link: =HYPERLINK("http://www.google.com/search?q="&A1&", "&A3&", "&A6&"&safe=active","Go") I think I'd like to move away from that to lessen the...

Hello all, Good day. I have excel in the below format. Excel 2013/2016A1List2CustomerA3CustomerBSheet1Cell FormulasCellFormulaA1ListA2CustomerAA3CustomerB In Sheet 2 I have data in the below format. Need to updated the validation field. Excel...

Hi I have the following formula all over a spreadsheet <colgroup><col></colgroup><tbody> #='Week 1'!I14 #='Week 1'!J14 #='Week 1'!K14 #='Week 1'!L14 </tbody> Is there a macro that will delete the # sign on all cells that have it in and then move the rest of the data back one...

Hey everyone, I'm new to VBA and trying to work out how to cut a row based on a single cells value and move it to the last row on the same worksheet. I'm also curious if this will cause some strange looping problem since that information would all be kept on one worksheet. No idea there. I'm...