cut and paste vba

Hi all - I have been trying for a week now through chopping up bits of code to try perform a report function to help with some data analysis but it is hopeless and keeps failing. I have 3 sheets within my work book: Master Data Data Input Duplicates All three sheets contains the same headers...

Hello I'm trying to move a row from sheet 1 "Chapter to Sheet 2 "Complete" using VBA for instance if A3 = "Cash" and L3 = "Refund" cut copy and paste entire row to Sheet 2 "Complete" and search the other rows if both criteria's are met then cut copy and paste entire row to Sheet 2...

Hi there, I have a excel sheet which is almost 11k lines and 11 columns big. Within the columns data is populated sporadically in the rows and I want to be able to bring this data into a defined structure. The defined structure is that Row 2 will be completed across all columns where there is...

Hi All, I have fields in rows for each record. Need to plot the same in columns. Data is in sequence i.e. each record starts with field name "ACCOUNT". Actual data is more than 10K and i need solution in VBA or other way by which data could be plotted in required pattern till end of data is...

Within a For Each loop - code below, I loop down Column V of a dimmed worksheet "wsr", so I assigned "v" as the range variable within Column V, so in essence it is a "For each v in ColV" situation. When a certain set of conditions is met for a given "v", I want to cut-and-paste the entire row...

Hi there, I have a question related to creating a macro in VBA (data and desired outcome below). I have a table in Excel, where in column A and H I have data. In column A there are classes and in the column H are students. I would like to have only one row for one class and currently I have...

Good Day all, long time / first time I've been on Google the previous day looking at compiling a series of macros to do the following (I will break up in to unique tasks): #1 : scroll through a workbook with 70+ tabs and find a uniquely named tab (that will change spreadsheet to spreadsheet)...

I had reached out previously about getting a code so that based on a selection in row A if it were to be switched to completed that the entire row would be cut and then put into the Completed tab. I wanted to see if I could get this code edited so that the same option for when it is completed...

Hello, I was wondering how to right a code to cut an entire row and paste in another sheet when one cell meets a specific criteria. I have a checklist in column A starting in A2 that has the options -, Pending, Completed, Denied, Mistake-Abandoned. I also have 5 tabs labeled Overview, Pending...

hello I have a spreadsheet with various columns/rows of data. what I am trying to do is if a cell in column A has a string of less than 4 characters (this could be either alphanumerical or symbol) I need to cut & paste the values from columns G,D,E & F only to a new worksheet (in the same...

Hi all, Can someone help with the below? I want to cut a row of data and paste it into a separate sheet based on the filter. Here is the code I have so far but an error appears on the highlighted line: Sub completecand() Dim FilterString As String ' With Sheets("HR Advice & Admin")...

hi guys, I'm new here so please forgive me if I have not posted accurately. the source is table format. I'm currently working on some code to copy paste an entire row to archived sheet based on a single column being filled in column I after the table headers from row 8 I have got the code to...