between worksheets

Hi Folks, I am looking for a way using VBA to do the following process: I have two worksheets: Sheet 1 (contains Table 1) and Sheet 2 (contains table 2). Worksheet 1: Table 1 - Column A contains serial numbers. Worksheet 2: Table 2 - Column A contains an index of all the serial...

Hi. My situation is this: Every week, I get a worksheet full of data. Some rows are relevant to me, and some are not. My goal is to quickly create a list of only the relevant rows. (I send this list on to others who are not interested in the process, so for the final product, I don't want it to...

I did some research and wrote out what I thought was a working formula, but it returned a zero. That's not what I was after. To set the stage... Worksheet 1 includes lots of data points. The relevant ones are dates (Column A), descriptions (Column D) and dollar amounts (Column F). Worksheet 2...

Hi There, I'm trying to copy formatting from a range of cells to a range of cells on another work sheet that will automatically update when the first one is changed. I found the below thread and tried to use the VBA scripts in it but to no avail...

I have worksheet1, worksheet2 and worksheet3 and I am trying to have excel do a compare of a cell in worksheet3 against a cell in worksheet2 and if a match is found copy the entire row of worksheet2 to worksheet1. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...

I am using an advanced filter to find all employees (from a master scheduling workbook) not available to work on a given workday. It is then pasted into a sheet in the weekly schedule. Is it possible to link this data in some way from that worksheet to another worksheet - daily schedule - to...