paste cell

I have a worksheet that has a 7 row header (some rows are blank). I am copying data from 3 different tables and need to paste it into the first blank cell after row 7. One thing to note is I also need to be able to specify the column to paste into as the data in the table isn't in the same...

Hi All, I'm trying to copy and paste visible cells only. for instance; I have columns A to Z but I columns C to H hidden When I use Alt+; or Find & Select>Go To Special>Visible Cells Only it selects only the visible cells. I can see the perforated line separating the columns. However when I...

Hi, I have a spreadsheet in Excel 2010 that contains a list of appx 1000 managers. Each manager on the list has a hyperlink to their spreadsheet in our directory. The spreadsheet also contains the password for each of the managers spreadsheets. The process today is for the end-user to...

Hi there, first time posting a problem on here so please be kind.... I am having a problem copying data from one file to another in Excel. This issue is unique to the destination file as when I create a new Excel document the problem does not present itself. I'm loathed to start from scratch...

Hi friends! To paste only values on the visible cells, i use the following macro: <tbody> Sub Copy_Filtered_Cells() Dim from As Variant Dim too As Variant Dim thing As Variant Dim cell As Range 'Selection.SpecialCells(xlCellTypeVisible).Select Set from =...

Hey guys, I've been lurking in the existing threads, but not sure how to approach it yet. Should be straightforward, but I'm not very competent with syntax. Consider this table. <tbody> Patient id - 336 Diagnosed Diabetes Type 1 Age 32 Insurance number GP notes text Patient id - 118...

I have been racking my brain trying to figure out a quick way to resolve an age old issue I have. I currently have a workbook with 3 worksheets in it. The first worksheet is the reporting sheet, the second is before data, and the last is after data. On the reporting sheet, cell A1 is equal to...

Hello everyone. I'm a new Excel 2007 user and desperately in need of help regarding macro programming. Right now, I have one worksheet that consists of several columns (A to J) with quite a number of rows as well. I desperately in need of help in building a macro that would enable me to...

I need some vba code to be able to copy and paste data from one sheet to another making sure the date at the top of the column is the same. :confused:

Hello. I am a new user. I was trying to copy the sum from sheet1 to sheet2 in the same work book with macro. I was using this code: Range(Sheets(1).Rows(36), Sheets(1).Rows(36)).Copy Destination:=Sheets(2).Range("A36") It works fine. The only problem is it is copying the formula, but not the...