I have a problem: I need to line the same people in column B and currently it looks like this person is always in one cell from A-H but not always in column B as desired. If this person is in for example column H then I have to move him/her to column B and person from column G to column A...
I'm trying to collate the data from sheets 2 through 11 onto sheet 1 of a workbook but I'm struggling with the macro.
How would I go about cutting and pasting the rows with data from sheets 2 to 11 (without headers) on to the next available row on sheet 1?
I would like some help with making this code below work for the 30 checkbox's I have. Is there a way to shorten it down instead of copy and pasting it 30 times?
If CheckBox1.Caption = "" Then CheckBox1.Visible = False
This macro should open up the file (Food room book 2), copy/paste the selected range into the SkutoSkutemplate and then close the page (Foodroom book 2).
I need help on this please. I need to use the value from cell (B5)'sheet1' in a filter on sheet2.
When I record my macro I am copying and pasting the value of B5 over to sheet2 filter and then copying and pasting the results back over to sheet1. This is working but the problem is...
Hi All -
Is there any way if I can make "D2" dynamic. I mean while pasting it to other Row or other Column "D2" should change to D3 or E2 ( Bascially I want to adjust Relative Reference concept while pasting.)
Any help would be appreciated.
Hi guys, I am going to say what I am trying to accomplish in words. I have a report I was doing manually. The info is imported into different workbooks from a master excel file. From then i was copying and pasting each row as of the different days of the month. This could be automated so I have...
I am having an issue with my macro. I have a button set up to copy data from one sheet and then paste it on another. A formula in one of the cells is pasting and changes when it gets paste, thus throwing a Ref error. I want to keep both the formatting and the value, so...
I have a spreadsheet with over 80 tabs. I want to collect the contents of Columns B and C on each of those 80+ tabs and put it on 1 separate tab without copying and pasting 80+ times. In other words a macro but the macro recorder does seem to quite get the index to next tab and pasting at the...
Is there a VBA macro to have data paste in the next free row, but have different cells paste not in order?
lastrow = Range("A65536").End(xlUp).Row
Cells(lastrow + 1, 1).PasteSpecial...
So I am currently copying data from one sheet and pasting it to another. The data on Sheet 1 is pasted vertically and all over the place (ie: Rows 16 through Rows 19, then Rows 125 to Rows 130). Then I have different rows being copied under different circumstances. So continuing the...
Hello. Is there a way to paste down a column into empty blank cells which has been filtered? Here's what I have so far, I've gotten to copying and pasting the last active cell in A, but need to move once cell down and paste the data mirroring the last used row in cell V. Column V always has...
Hello. Just a quick question. Is there anyway to tell VBA to stop pasting my data by referring to end of another column for which there is data? I'm trying to paste info down a blank column and have told it to stop at row 200, but the data range always changes. For instance the end row may be...
Hi! I'm trying to copy a range of cells to a second sheet and then delete the row from the first sheet. It seems like it should be pretty simple but the code is throwing an unknown error and highlighting the line "Sheets("Sheet1").Range(cell1, cell2).Copy"
Any ideas why this would be happening...
How do i stop users pasting data from one workbook into another.
When i disable copypaste in the workbook it stops pasting within the workbook but when i copy from another workbook it lets me paste
Can anyone help?
I have a quite simple Excel sheet with two tabs in it (Sheet1 and Sheet2)
Sheet 2 contains numbers in row Q and hyperlinks in column T
Basically any time when there is a number "1" in row Q, macro should copy paste hyperlink from reflective row to A4 in Sheet1, call few macros and...
Hi, I'm trying to paste data from cell L1 (the word "Rental") to the last cell in column G, but it's pasting in the wrong cell, it should paste in cell G40 as that is the last blank cell, but it's pasting in cell G6988 and then I want it to copy the word "Rental" to the last cell that has data...
Hi, question on pasting in data from an excel file into another excel file - and I'm not even sure this possible, but wanted to see if it is.
I basically want to have a macro that pops open a File Open Box that allows you to select an excel file. Once you select that file, the macro references...