cut and paste

1 Workbook 2 Spreadsheets - "Complete Backlog" & "Closed Jobs" If Column K in "Complete Backlog" says "Closed" then cut that row and paste it into the next available row of "Closed Jobs". I have this code below but there is an error with it. It currently cuts all of the items marked closed but...

I'm using 2003 (company computer :( ). I need the macros to manipulate cells not entire rows So here's the algorithm: If a cell in Column K of the "Complete Backlog" spreadhseet is equal to "Closed" then cut cells A?:K? of the same row and paste into the next available row of the spreadsheet...

Hi, I'm trying to cut rows with the word "FBO" in column B, and move them all to a new sheet, title that sheet "FBO Accounts", and delete the rows on the original tab where the FBO accounts were and would now be blank. So an example: There are 100 accounts, 62 have FBO in the name which is...

Hey, So I am relatively new to VBA and am having some issues. What I am currently trying to do is to remove or clear a row that has been formatted with strikethrough. My list must remain at 1000 rows with the same formatting (color, size etc). One way I have been going about this is clearing the...

Hi, I have a huge list of data and what i would like to do is be able to sort out the data using the subtotals that equal 0. basically it looks like this: <TABLE style="WIDTH: 812pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1079 x:str><COLGROUP><COL...

Hi, I have a excel workbook which has a number of name ranges within it which are regonized as part of a macro when it run. The problem i have is that when people fill it in they sometimes Cut&Paste cells over the named cell/range which causes the named range to be edited by the cell that...

Hi Experts I'm a newbie to VB and I am trying to figure out how to cut and paste data from the first work sheet into other work sheets. Here is the catch however: Sheet 1 has 10 tables that is cascading. therefore i need to figure out a way to cut and paste each table into a new work sheet...

Hello experts, I’m new to Excel, but I’ve grasped the concept of basic macros in VB. I’m now trying to create a macro that cuts and pastes whole rows into a different sheet depending on whether they have a particular word in any column. This is a little beyond my expertise, and I would be very...

Does anyone know what this is? It's intermittent - I can ctrl-c on the same cell in the same workbook 10 times and it will pop up 3 times. Do it again and it will pop up 7 times. There doesn't seem to be any rhyme or reason to it.. It's annoying. I'm using windows xp sp3 and excel 2010. A weird...

Using Excel 2007 under WinXP, I am trying to prevent defined names from getting moved when the user performs a cut and paste from one cell to another. My worksheet is a data entry form wherein all cells are locked except for the cells where you enter data. Each one of these data cells has a...

Hi, I would everything in my workbook to be in Times New Roman font, so I just select all cells and set the font to that. However, since the default font for Excel is Calibri, every times I cut a cell, the font of what's left behind is reverted back to Calibri. I have tried to solve this by...

Trying to move the "Misc. Rev" Column to the right of the "Veratax" column. What am I doing wrong? I don't want to specify the exact cells because the position of these columns can change. But, all my attempts to copy, go to another part of the sheet through searches and arrows, then paste in...

Hi guys, I'm hoping someone can help me. I think my request will be pretty simple so here goes: I have a 2 tabs in a workbook 'Sent' and 'Returned'. In the 'Sent' tab are a list of documents which have been sent out. When they have been returned, I would like the row to be cut and pasted...