I have written a basic vba code to select bunch of rows from one sheet based on data paste it in another sheet where i perform duplicate removal and then I cut it and paste it in another sheet to get duplicate removed output, how to improve my code as the copy and pasting operations takes soo...
Hey All!
I have my trusty old glorified copy and paste code but I am looking to link the line that has my Workbook name to a cell in one of my sheets. Can't seem to figure it out.
Sub GrabIndEquity()
'Update Data
Workbooks.Open Filename:= _
"T:\FILE1\FILE2\FILE3\FILE4\FILE5\DATABASE...
Hi,
I’m wondering if someone could help me please as I’m struggling to get this working. A button click runs a sub containing two with statements. The first one (with ws) works fine. This finds certain records from the main list in worksheet ws, it copies selected columns and pastes the...
I have a spread sheet that consolidates multiple worksheets into one. Then, the user sets the page breaks. Next, the user can hit a "PDF" button and it will export to pdf. It looks great - exactly as it does in excel. But, I cant quite seem to get the Word export to work.
When the "Word"...
Hello all,
I am trying to create a passenger manifest form. I have sheets for each day. I Have a userform that outputs to sheet called "Master", need to copy Cells D2:N2 from sheet "Master" and paste into a specific location on a specific day based on user entry. I would like to prompt the user...
Something like:
In spreadsheet "Complete Backlog", if a cell in Column K = "Open" AND the cell in Column G of the same row = "Snodgress" THEN copy cells A?:J? and paste into cells A?:J? of the "Snodgress" sheet. Of course skipping to the next available row and also the content should not repeat...
Hey Guys,
I know you have gotten this one a bunch before, but I can't find a way to do the couple things I need this to do. I'm really close however, so it shouldn't take more than 5 minutes hopefully.
What I need.
Open multiple files at one time, copy and paste certain cells in those files, to...
I want to create a macro that when date is inserted into certain cell, have the whole line moved to a new worksheet, and re move from original sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p> </o:p>
attempted to create the formula, but...
Hi all, this is my first post so I apologise for my lack of forum lingo and knowledge!
I have a situation where I have a rather large spreasheet, that we populate each week with 35 columns and 20,000 rows worth of data. At the moment we have to manually go through this data and look at certain...
Windows 7<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
Excel 2007<o:p></o:p>
<o:p></o:p>
PROBLEM: I have completed my loop through all the sheets in my workbook. All my data is copied to a “Results” sheet that looks like this. Player 1 has been copied...
Windows 7
Excel 2007
GOAL: My intent is to create a single workbook. Sheet1(pga_list) will be used for data purposes and will be referenced by all other sheets through a data validation variable and vlookup values. This I have done. I wish to add an indefinite number of sheets beginning at...
I have an Excel Workbook that has approximately 200 sheets in it. What I am trying to do, for example, say I have two sheets that are essentially identical. On sheet one I want to create hyperlinks to the same cell in sheet 2. I know how to do it one at a time, but I would like to do is be able...
Hoping someone out there can help me. I am new to macros and do not have a clue where to start.
I have a worksheet called "Entry" and there are certain cells in which data is entered into. There is also a command button that when clicked I would like it to do the following:
1. Copy data that...
Hey all! I was wondering if anyone knew copy range G15:H600 from excel to word, paste it, and then copy it back from word to excel in the exact same location from whence it came - all using late binding. I've been trying everything I can think of, but I have very little experience in this...
I have a column (A) that can contain wither text or numbers.
I have set the number format to be with four decimals and % (ie. 12 would be 12.0000%).
I want to protect that number format. The column is already protected, but if people copy a number from another column X (say, the copy the number...
Morning all,
Can anyone help me with this one:
I need a macro to look at a list (which has been previosly filtered by the same macro) and copy certain columns in that list to be pasted into another workbook. The problem is, the length of the list will change frequently depending on the...
Hi There!
I have Sheet1 in workbook "DATA.xlsx" that has data. I.E.
column1 column2
567 John
567 May
123 Kate
567 Larry
456 Bill
I would like Sheet1 in ANOTHER workbook "SUMMARY.xlsx" to list all of the people who meet the number criteria I type in...
It is a trivial problem but I am so newie, sorry.. The Idea is that recursively with a for check the value of a columm if the value is "I" then I should cut some consecutive cells from that row and paste them in the same row but with some cells displacement... it is pretty much a selective copy...
I've just signed up and i hope somebody can help me out.
I'm tryin to write a macro that will:
- find the condition columns in a spreadsheet (their headings are coloured light turquoise)
- check if each is populated
- if it is then copy each individual cell's info and the column name,(e.g...
I am working on a project that reqiuers book2 to cpy from book1 and paste ifromation in book2.:(
But book 2 must copy from book 1 a single cell that has a letter to match informatin copied before then place the letter to auto fill to the end of information coppeid first it should look like...
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.