I am doing a financial statement for a person but I did not create the workbook. The book has two sheets linked together. I am overwriting the names and numbers from last year's form. I have run out of lines on the first sheet and don't know how to copy and paste the macro to the bottom of the sheet so that I can carry on with inputting my numbers. Here is a sample of the workbook.
I'm working my way through a list of companies on an excel spreadsheet and making some notes.
After i've spoken to them its a simple keep them on the sheet in the current position or highlight the row red and move to the bottom or when they become a customer highlight green and move to the bottom.
I have a coloumn called customer (J) is it possible if i put a Y in that cell to make the row green and move to the bottom and also if i put a N in the column make the row green and move to bottom.
I have made a chart in Excel to show the half life of cells for a science project so it basically has days along the horizontal axis and percentage on a logarithmic vertical axis. However, the horizontal axis always appears at the top of the chart when I use a vertical log scale (if i dont use logs then its at the bottom where it should be). Is there any way i can move it to the bottom? i've tried everything i could think of under "format axis".
I need to move the rows from one sheet to another sheet upon clicking the ‘Submit’ button.
I will manually update my efforts in ‘Sheet 1’ and when I click ‘Submit’, it should “copy” the rows to the next sheet (Sheet 2). However, it should not duplicate the entries irrespective of clicking Submit multiple times. Obviously, while clicking ‘Submit’ it should check the entry for that particular employee name and date in the ‘Sheet 2’ and remove that completely and update the new entries and this should avoid duplicates for that date. Every time when I add new entries for a different name and for dirrerent employee, it should keep appending the Sheet 2.
In addition, it should avoid copying the blank rows from Sheet 1 (S. No column will not be blank usually) to Sheet 2.
All this should happen upon clicking the Submit button.
i learned how to highlight a row by placing an X in a single cell, my next question is:
Is there a way (most Likely there is) By placing "J/C" into a cell, make the entire row cut and then insert itself into my second sheet on row 2? "insert into a new row and not over existing information?"
now i have done this in the past using a Macro, select the row and then by pressing ctrl+k it would cut the row and then insert it into row 2 of the second sheet.
It is supposed to take the rows with striketrhoughs and transfer them to the other sheet.
Private Sub Worksheet_Activate()
If Cells.Font.Strikethrough = True Then Rows.Select Selection.Cut Sheets("Completed Deployments").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True End If
I need to update a sheet called Database by filtering the word Served in column F (6th field) of another sheet called Detention Register. After the 'Served' rows have been filtered today's date needs to be pasted into column E for all of these rows.
The filtered entries from A:F only then need to be cut & pasted into the next empty A column cell in the Database sheet. Finally, another macro called Update Database needs to be called.
I have a spreadsheet that contains large amounts of data. I've looked through the forums and tried to adapt other VB code to work for me all to no avail.
I would like a macro to automatically cut a row from sheet1 and paste it on to a new line in sheet2 when data is input into column 'X'. (The data input in to column X is a date the specific case is resolved)
I want to do is copy all rows from the worksheet DATA based on column G (Date) and copy it to a new sheet based on the date (all 2003 on the 2003 sheet and all 2004 on 2004 sheet.....).
I have already created the new sheets including headers minus data. I would like to have all the data moved except the last to Columns AW & AX. I have two hidden sheets in this workbook. Would it be possible to have it auto-populate future entries from the "DATA" worksheet to autofill onto the new sheets?
Just noticed that I titled the Thread with Move but what I am asking for is copy. I cannot change the Thread title.
i am making a simple complaint tracking system and there is a column where there are two choices Resolved and Unresolved if you choose resolved it copies the row to the resolved sheet and if it's unresolved it copies the row to the unresolved sheet. i attached a template to give you an idea, i want the first complaint to be copied to the resolved sheet and second one to the unresloved sheet, i don't want the status column which contains the choices to be copied to the other sheets, also the unresolved sheet doesn't have a 'date closed' column because the complaint is not yet resolved so i dont want it to be copied there, i want it only in the resolved sheet.
I have been trying to do this for 3 days using "Record Macro", but something always seems to be messed up. The main problem is that the worksheets are protected and the macro asks for the password.
Here is a calendar sheet that I've been working on. It contains the calendar on sheet 1(not important) and a client roster on sheet 2. The client roster gets filled quickly, and obviously gets unorganized. What I'd like to do is create a macro so that when a date is entered into column AA (when a client is discharged), that entire row is moved onto sheet 3 (Discharged). At the same time, I'd like all of the names in column A alphabetized.
I even tried to create an "Organize" button so that the users could just click it and alphabetize. The problem I ran into with that was that the users are using Office 2000, and the names get alphabetized but all of their information no longer matches up.
I would like to have a VBA code to the following:Please note that the rows are dynamic and I need the results row for every customer.Currently it is totalling and displaying the results column at the botton of every customer but I need it at the start of every customer
1.When the new customer number starts the cells are shifted and moved one row.
2.Insert the results word and it displays the results thats displayed currently at the bottom,shoudl be displayed at the top where the row gets inserted in (1)
I have a spreadsheet in which the user will respond to questions using "T" for "True" or "F" for "False". If there is a certain number of T's I would like the macro to take the user to one sheet in the workbook or if there are a certain number of F's I'd like it to take the user to another sheet in the workbook.
I have a worksheet that has time clock information. I also have a resource on the web to see some information and even export it. In the exported data it looks as follows:
A1 contains an individuals name B1 says times i.e. "8am to 5pm"
I would like a macro that takes the data from A1 and moves it to another worksheet in the B4 position down, and take the times from B1 and move the first time to the C4 position and the last time to H4.
I am using Excel 2010 and need a macro that can convert data from rows to columns. I have read several posts about this subject but have no experience with macros and don't know how to change the macros to fit my scenario.
I have approx 150 rows on my spreadsheet, but I am having difficulty viewing the bottom rows. The slider bar on the right hand side actually disappears on the bottom of the page. I am using windows 8. changed the tool bars and that worked, but I want to see the tool bars.
I am only using 581 rows in my worksheet. Excel's scrollbar lets me scroll down to 682...
I have tried everything from Google ranging from... - Selecting all the blank rows, deleting them via right click menu - Saving and re-opening the workbook - Running pre-made macros, making my own macros
Quick way of inserting the same rows into the bottom row of different tabs, the difficultly comes as the bottom row of the other tabs varies. I.e tab 2 the bottom row is row 87, tab 3 the bottom row is 53 etc.
A common process is to select one or more entire rows. Is there a way wth VBA after working on the slected row or rows to have curosr drop below the last row and select just the next row eg. I selected entire row 1045 then when done the cursor will drop down one row and select row 1046. However, if on rows 1045, 1046 and 1047 that the cursor would drop down and select row 1048.
Is it possible to use the import external data function in excel to import only the bottom 1000 rows from a database? Right now I've only been successful at importing all the data but I only want the last x number of rows. The database is currently an excel file.
I am looking for a shortcut key or some fast way of getting to the last line of information on a excel spreadsheet.
I currently have order spreadsheets with over 10000 lines used and everyday I need to add more lines and if I have used the Shift+F to locate an old order then I can be say sat on line 40 but my last inputted text could be on line 7000 and I would like to know how I can get to that line without knowing the line number.
The shortcut must take me to the last text entered cell not the last cell on the worksheet.
I need to build a macro which copies 3 rows every day and pastes the row data into an identical sheet. The three rows will have column "D" as =today(). As the days progress the three rows will change accordingly ( tag to the today's date)
e.g. 28/1/2014 28/1/2014 28/1/2014
I need the macro to recognize the date when pressed and copy the corresponding rows of data and paste them into an identical sheet with the same date. The second sheet is an archive sheet. The date will tick over as per the calendar.
I have a TAB Named: Sheet18. I already set up the Header rows to print at the top of every page. Now I need to know how to set up to print the Footer at the Bottom of every-page the footer is A4804:Z4806, i need this rows printed at the bottom of every page when i print.
Note: Split from: VBA to insert page breaks at a blank with varying blck size
I would like my macro to add empty lines to each pages not completely filled. (you know when it removes a block from a page, there's always some free space at the bottom of that page) Is it possible to add blank row (from a certain template on another sheet that I have) until it's full?
I am using the following codes to hide the menu, formula bar and the headings. One more thing I need to do but do not know how - hiding the tabs at the bottom of the sheet. The idea is not to let users to right click and unhide other sheets.
'Hide main menu Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" 'Hide headings ActiveWindow.DisplayHeadings = False 'Hide formula bar Application.DisplayFormulaBar = False
I have a macro that I recorded which is supposed to copy the contents from row 38 of my calculate sheet and paste the values of it below the last record on my monthly summary tab but it is not pasting below the last row of data. It keeps pasting to the top record. My code is below: