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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.