copy & paste formatting

Is there a way to copy and paste formatting from a range of cells on one sheet in a workbook to the same cells on multiple other sheets at the same time? I have a timekeeping workbook where I have 52 tabs where each tab is a week for tracking hours worked. I need to go through and adjust...

i keep wrestling with the copy and past between workbooks/worksheets. The code below prompts for a range date then selects data from a worksheet based on the date entered and successfully creates a new workbook and copies the correct data. However the new sheet isnt formatted the same. This is...

Hello Everyone, I'm sure there's a similar thread out there that addresses this issue, but I'm having trouble applying the correct codes to work with my spreadsheet. There are two things I want to do here: 1) Dynamically insert text into next empty row with userform 2) Copy specific...

Hello! I've just started working with vba and have some difficulties with a code to copy and paste. I have 2 workbooks, the first one is called months and the second summary. In months there is a worksheet for each month (JAN, FEB, ...) and every month some rows of a table (B3: E15) are filled...

Hi Guys, I've made research about this but can't find the right one. So I have this excel sheet named "Subject" with multiple sheets (sheet A to D). What I need is to find the codes wherein the macro will copy the entire format of Sheet A to Sheet B,C & D. Any help will be much appreciated.

Good morning eveyone, I have sheet1 where I past information from SAP. In a second tab and for each line in sheet1 I have to copy past the info on 6 lines What I did is cell A1 of sheet 2 is "=sheet1!A1" cell A2 to A6 "=A1", ="A2" etc.. Problem is, I have about 500 lines in sheet one, and when...

Hello all! I'm a basic VBA macro-er and after going through plenty search-results trying to find a solution to my problem I finally opted for posting on a forum. So please don't get too impatient with me when you see how basic my question might be. Its regarding dates and keeping the...

Hello All, I have code that copies a subtotal line from a main sheet then pastes it on everysheet in my workbook and it used to paste the formatting but now its only pasting the values/formulas and not including formats. Here is the code with a comment on the line I need updated Dim ws As...

I have created a spreadsheet with different conditional formatting set up for each column in a row. I am able to copy this "source" row to another row - the cell references within the formula used in conditional formatting are correctly updated. Furthermore, the range the conditional...