VBA code needed to insert row data from another sheet and fill down formula and format

[krjoshi]

Hi Folks,

I have a workbook with two sheets, first sheet for user input and second sheet is for summary with formula and specific format. I want a VBA code to auto update / insert data from the input sheet and copy all formula / format from above rows. I have attached an excel file of what I'm trying to accomplish.

Thanks in advance for your expertise!

Joshi

[krjoshi]

Folks,

Please help me...???

Joshi

[jaslake]

Hi Joshi

Is Sheet P6_input TRULY a User Data Entry sheet?

[krjoshi]

Hi John,
Thank you so much for your reply. Yes the P6_input sheet only for enduser to key in or paste the data.

Joshi

[jaslake]

Hi Joshi

I need to understand the User Process.

How do they physically ADD items in P6_Input...do they simply INSERT a Row?
How do they physically DELETE items in P6_Input...do they simply DELETE a Row?

If you can detail the process it would be extremely helpful...step by step...assume I know nothing...'cause I don't.

[krjoshi]

Hi John,

Please see the below details as requested.

1.*******The user will clear all data by selecting Cells “A1: F” and press delete key or Home-Delete Contents from the “P6_input” sheet.

*

2.*******The new data will paste as values into “A1: F”* in “P6_input” sheet (Please note that the new data they are getting from Primavera Project Management Software every day, and* the rows data may vary).

*

3.*******Hit the “Set All Data” button in “Conversion” sheet, then all data to be inserted into “Conversion” sheet from “P6_input” sheet (The data should be inserted in between Row # 4 and Row # 19 since the “Chart” data sources are “A2:I21) and to be filled all existing formulas and format to the newly inserted data too. These data structure and formula are allow me to view the chart in existing format.*

*

Hope this will help you to understanding my needs.

*

Thanks,

Joshi

[jaslake]

Hi Joshi

I'm not a Formula person so I'm probably not the best one to be looking at this. However, if you wish me to, please post several examples (4 or 5 or 6) that represent the different variations of this.

the new data they are getting from Primavera Project Management Software every day, and* the rows data may vary

Place them in a new workbook and upload. Please include the most extreme example and the simplest example.