copy & paste formula

Hi Team, I need some help, I have 7 columns data in sheet1 and this is the reference of original data from Sheet2 (through the formula) both data sets are same. I am not sure if this can be done via worksheet change request. If I change the cell value in any rows then that entire row till...

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...

Dear Sir or Madam, I am looking for a VBA Excel Makro with the following action: I have an excel workbook with many sheets. They are all set-up the same way. I need to copy&Past always the last row within a sheet with the formula and copy&Past thereafter the row above with Value within the same...

Hello. I have a problem with the VBA using the copy paste formula to copy the entire content of the table into one single cell (as an active formula) I've attached a simple table for a demo. I've noticed that even as normal user you cannot simple copy - paste a table then double clicking into...

I'm trying to use the TRIM function on several hundred rows, but when I try to copy the function down the column by double clicking the bottom right corner of the cell containing the TRIM function, the exact string in that cell is copied down instead of the formula. Does anyone know why this...

Hi, I'm an excel formula newbie and was having trouble trying to figure out the correct formula to do the following: In Column A I have a list of various values ranging from 0-4000. I'd like to reorganize them (or recopy them) into 3 columns delineating the values into certain ranges based...

Kind of confusing title, sorry about that! Let me elaborate... I have the following formula in a cell: =LEFT(INDIRECT("Source!A2"),FIND(" ",INDIRECT("Source!A2"),1)-1) *(Don't worry about what the formula actually does.)* Basically, I'm trying to drag this cell down about 1000 times for...

Currently I use a macro to create a workbook with everyday of the month as the title of every tab. I am able to copy the template, that I have created, for each spreadsheet but it can get annoying to have to go in and copy and formula paste every time. Here is my current formula: ‘Code Starts...

Hello All, I am having table with some formulas inserted, by inserting unique values in desired cells, it gets calculated with the formulas. this is my daily task, and I have to copy this table from previous spreadsheet (SS) and paste it into new SS for fresh data. Earlier it was copying and...