You will get excel macro for automation in ms office | excel database to excel template
You will get excel macro for automation in ms office | excel database to excel template
Upto 10 data items
excel macro for automation in ms office | ms excel database to ms excel template
- Delivery Time 2 days
- Number of Revisions Unlimited
- Number of Macros 1
- Number of Buttons/Forms 1
- Data Source Connectivity
2 days
delivery —
Oct 15, 2024
Revisions may occur after this date.
Upwork Payment Protection
Fund the project upfront. azhar gets paid once you are satisfied with the work.
Project details
You will get the ms excel macro that will, by clicking a button, get data from your ms excel database (source of data) and populate it in your ms excel template (target file) and saves it according to your desired name (ID, Roll #, Name etc. + some text as desired).
Details:
You will provide the database, template and clear instructions as to where data get from and where to populate
We will name the ranges in your database & template so you need to use the same database and template for future use.
If you don’t want to share your data with us you will name ranges yourself through a Zoom meeting with our team. Thus you don’t need to share your sensitive database with us, yet you can share only the heading row and 1-2 entries to testify the macro.
Note:
If you forget to place database or template in a required folder, Macro will notify you to place the file in the folder
If the desired record (ID, Roll #, Name) is not found, macro will notify “Record is not found, try with the valid record” and exit.
Upon validating all the above, the macro will perform the required task in (ms office) within seconds and with 100% accuracy.
Thank you
Details:
You will provide the database, template and clear instructions as to where data get from and where to populate
We will name the ranges in your database & template so you need to use the same database and template for future use.
If you don’t want to share your data with us you will name ranges yourself through a Zoom meeting with our team. Thus you don’t need to share your sensitive database with us, yet you can share only the heading row and 1-2 entries to testify the macro.
Note:
If you forget to place database or template in a required folder, Macro will notify you to place the file in the folder
If the desired record (ID, Roll #, Name) is not found, macro will notify “Record is not found, try with the valid record” and exit.
Upon validating all the above, the macro will perform the required task in (ms office) within seconds and with 100% accuracy.
Thank you
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$10
|
Standard
$30
|
Advanced
$100
|
|---|---|---|---|
| Delivery Time | 2 days | 3 days | 5 days |
Number of Revisions | Unlimited | Unlimited | Unlimited |
Number of Macros | 1 | 1 | 1 |
Number of Buttons/Forms | 1 | 1 | 1 |
Model Documentation | - | - | - |
Data Source Connectivity | |||
Toolbar Integration | - | - | - |
50 reviews
(45)
(4)
(1)
(0)
(0)
This project doesn't have any reviews.
CO
Chris O.
May 9, 2023
Excel data creation
Great to work with. Was extremely helpful. Unfortunately our project had a shift in direction but would definitely recommend.
TM
Tomomi M.
Feb 6, 2023
【Simple Copy Paste Work】**Hand-pick potential customers
CM
Chris M.
Mar 2, 2021
Excel Modeling
Azhar always meets deadlines and provides the highest quality work. I'm very impressed with his excel and data modeling skills.
VA
Virtual A.
Jun 9, 2020
MYSTERY SHOP EMAILS
Fabulous freelancer! Works very well with very little guidance needed. Super enthusiastic and a pleasure to work with!
TC
Trevor C.
Apr 27, 2020
Data and Image Minor Modifications - Five Cents Per Revisions
Great experience, worked fast with precision and quality.
About azhar
Excel / Google Sheet : Macro | Formulae | Power BI
100%
Job Success
Lahore, Pakistan - 12:15 am local time
I’m Azhar, your go-to guy for making Excel work wonders for you. I’ve spent over ten years turning complex data into clear, useful spreadsheets that help businesses run smoothly. My services include:
-- Power BI Dashboard:
• Data Visualization
• Interactive Dashboards
• Data analysis
• Decision making insights
• DAX Query
• Data drill down
-- MACRO & VB Scripting:
• Macro for excel to excel (report generation etc.)
• Macro for excel to word (agreement generation etc.)
• Macro for excel to PDF (PDF creation etc.)
• Macro for web to excel (data scraping) and more....
--Function & Formulae
• Financial Calculations
• Statistical Analysis
• Data Cleaning and Manipulation
• Conditional Formatting
• Lookup Functions
• Logical Functions
• Date and Time Calculations
-- Data Organization & Management:
• Workbooks & Google sheets
• Excel template creation
• Data Entry & Editing
• Data Validation
• Data Sorting & Filtering
• Data Consolidation & Merging
• Data Pivot Tables
Please get me to chat for further discussing your requirement.
Thank you very much.
Steps for completing your project
After purchasing the project, send requirements so azhar can start the project.
Delivery time starts when azhar receives requirements from you.
azhar works on your project following the steps below.
Revisions may occur after the delivery date.
Instruction
Clear Instruction will be provided.